Re: AWM Problems

Hello

Now I have no more generation problems.

I have created two cubes. Now when I will use them in JDevelopper I don't have data or with the second cube I have the wrong data. I receive only one value, it doesn't make a sum aggregation.

The same result in Cube Viewer.

The database which I use is the foodmart database from sql server... I want to make my own test. BIBDEMO was running correctly...

"Kägi" <cretdami_at_students.hevs.ch> wrote in message news:3fc34263$1_at_news.vsnet.ch...
> I have still have no data... I think the problem is the time dimension.
>
> Does I have to choose a new time dimension or can I also create normal
> dimension object???
>
> I tried also to make a time dimension, but when I created the Analytical
> Workspace I received the following error message:
>
> Processing Refreshing Dimension : AWF_TIME
> Error Message from Server = Problem loading source data for:
> FOODMART
> TIME
> (LDXERR00) Error code 1840 from Oracle LDX package.
> In SYS.AWCREATE!___LOAD.DIM.DATA PROGRAM:
> &_end_date_attrt = &_end_date
>
>
> SqlException = ORA-06502: PL/SQL: numeric or value error: character string
> buffer too small
> ORA-06512: at "OLAPSYS.DBMS_AWM", line 1002
> ORA-06512: at line 1
>
> Error Code = 6502
> Sql State = 65000
> Error Message from Server = Problem loading source data for:
> FOODMART
> TIME
> (LDXERR00) Error code 1840 from Oracle LDX package.
> In SYS.AWCREATE!___LOAD.DIM.DATA PROGRAM:
> &_end_date_attrt = &_end_date
>
>
> SqlException = ORA-06502: PL/SQL: numeric or value error: character string
> buffer too small
> ORA-06512: at "OLAPSYS.DBMS_AWM", line 1002
> ORA-06512: at line 1
>
> Error Code = 6502
> Sql State = 65000
> All the cubes could not be added to the Analytic Workspace AWFOODMART;
> The following cubes could not be added : SALES BUDGET
> java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error:
character
> string buffer too small
> ORA-06512: at "OLAPSYS.DBMS_AWM", line 1002
> ORA-06512: at line 1
> Tidying Up
> Failed to create the analytic workspace
>
>
> "Kägi" <cretdami_at_students.hevs.ch> wrote in message
> news:3fbbe31b$1_at_news.vsnet.ch...
> > Hi
> >
> >
> >
> > I use JDevelopper 9.0.3.3 with BI Beans on 9.2.0.4.1.
> >
> >
> >
> > The BIBDEMO I successfully tested. Now I have created new dimensions and
> > cubes on another database.
> >
> >
> >
> > Then I created an analytical workspace with awm and enabled for olap api
> and
> > bi beans.
> >
> >
> >
> > after when i start the jdevelopper i can choose my own measures.
> > (http://home.datacomm.ch/crettaz/PresentationWizard.jpg)
> >
> > Here my first question. When i create the aw and enable it for olap api
> and
> > bi beans, i can see my dimensions and measures for two times. First time
> in
> > the folder "Foodmart" and a second time out of the folder generated by
aw
> > (normally with prefix). Why it will appear two times???
> >
> >
> >
> > Now when I wan to create a presentation, it shows me an error message.
> > (http://home.datacomm.ch/crettaz/ErrorMessage.jpg)
> >
> > when I choose the first one in the "foodmart" folder. Jdevelopper
creates
> > the presentation nevertheless.
> >
> > (http://home.datacomm.ch/crettaz/FoodmartFolderPres1.jpg)
> >
> > But how you can see without the correct header names...
> >
> >
> >
> > When I chose the second possibility.
> >
> > Jdevelopper creates the presentation without any error.
> >
> > (http://home.datacomm.ch/crettaz/withoutFolderPres2.jpg)
> >
> > But without data and not correct.
> >
> >
> >
> > Very strange... Can somebody help me, please???
> >
> >
> >
> > It's very urgent...
> >
> >
> >
>
>
> ------------ And now a word from our sponsor ------------------
> For a quality usenet news server, try DNEWS, easy to install,
> fast, efficient and reliable. For home servers or carrier class
> installations with millions of users it will allow you to grow!
> ---- See http://netwinsite.com/sponsor/sponsor_dnews.htm ----

• And now a word from our sponsor --------------------- For a secure high performance FTP using SSL/TLS encryption upgrade to SurgeFTP ---- See http://netwinsite.com/sponsor/sponsor_surgeftp.htm ----