Re: AWM Problems

[Quoted] 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
[Quoted] 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 ----