Keyfigure not showing up in Web I report

[Former Member]

I have created a BEx query based on a multiprovider on top of a DSO and cube. We have two key figures from the DSO and one from the cube. The BEx report shows all the three key figures, but the web I shows only one keyfigure based on the cube with the other two (based out of DSO) not showing up any values.

Are there any design considerations in the universe designer to display key figures from different infoprovider types?

Thank you

V

[MariannevL]

Hi,

First of all it is good to state the version of BO you are working with, XI31 is very different from BI40.

Reporting straight out of a DSO is not recommended, but it is possible (I've done it XI31).

However, WebI being WebI you might be better off create a query/universe on the cube and one on the DSO separately and combine them in WebI by merging on the common dimensions.

That said: when you say, the keyfigure doesn't show up, what does that mean exactly.

You generate the universe and it doesn't get generated?

Or you run the report and do not see any values in the keyfigure?

In the latter you may have a selection that is preventing you from seeing the DSO values.

How are they 'linked' to the cube, are all the characteristics you use in the report both in DSO and cube?

What if they are only in the cube, are the keyfigures set to constant selection for the missing ones?

Is the key figure set to database delegated or straightforward sum()?

Did you try to run a query on just the DSO keyfigures (no dimensions, no keyfigure from the cube)?

Post back with a little more info and we may be able to help...

Good luck,

Marianne

[Former Member]

HI Marianne, Thanks for getting back.

We are on BO 3.1 SP3. The

By Keyfigures not showing up, I mean the values of the keyfigures do not show up in the web I report. The keyfigures are generated in the universe level.

Further Information on the infoproviders-

3 infoproviders are used in the multiprovider. 2 DSOs and 1 cube.

The cube and one of the DSOs have the same characteristics but the keyfigures are different. The amount keyfigure in cube needs to be summarized. We have two more amounts in the DSO that does not need to be summarized.

I can see the key figures on the DSO and cube querying them separately. I also see the keyfigures( DSOs+cube) when querying on the multiprovider but not in the web I report.

The keyfigures in the universe are set to database delegated. I tried changing them to sum(), didnt work.

Hope this helps

Thanks for your help again.

V