how can i use bw7 olap infocube datasource to create universe?

[Former Member]

hi experts,

i have config IK2.0 connect to bw7, but when i create universe from bw7 infocube datasource, the "OLAP DATASOURCE" page shows:

**.*.*.* (IP)

$INFOCUBE

1. ($0RSTT_C04)

...

ztestCube ($zTestCube)

the cube "ztestCube" created in bw7.

when i create this universe by "ztestCube",

Unhandled Exception：

1 processor x Family 15 Model 0 Stepping 0

Windows 2000 Workstation v5.1 build 2600 (S)

Physical Total/Avail: 916.720 Kb / 107.712 Kb

Temp directory C:\DOCUME_1\hgh\LOCALS1\Temp\ (2 Kb available)

'Unknown' video card

1024 x 768 in true color

-

---

............

how can i solve this problem,

thanks.

[Former Member]

thanks.

[Former Member]

thanks ingo and Roland,

but how can i use bw query to create universe ?, it only select OLAY Infucube datasource? i use Designer.

i understand Crystal Reports XI2.0 can create report use SAP BW Query.

thanks.

[roland_hoeller2]

Hi

You need to release the query for OLE DB

Open the query in the Bex Query Designer click on Query > Properties > Advanced and tick "Allow External Access to this query"

Then you should see the query in Designer

Roland

[IngoH]

Hi,

to explain why we recommend a query vs cube:

- when connecting to a cube directly you will lose the following functionality

- restricted keyfigures

- calculated keyfigures

- SAP variables

- structures

- navigational attributes

ingo

[roland_hoeller2]

Hi Xwu

Are you using Designer or the Universe builder?

If it is Designer:

-Make sure you have the latest Service Packs for both Business Objects and the Integration Kit installed.

-It is recommended to create a universe on top of a Bex query rather than a cube

Roland