Unable to see the Noncumulative Key figures in IDT

[former_member223477]

Hi,

We are developing an universe based on the multiprovider in Information Design Tool, but here we are unable to see the Non cumulative key figures like 'Stock in Transit' in Information Design Tool.

Could anybody please suggest me how can I get this in universe or how can I find the logic for that non cumulative key figures.

Thanks,

Krishna.

[former_member199945]

Cretae  Bex  query (Non CUmulative KFG's) For That Multiprovider & use BICS connection & connect to webi    & check once .

[deshmukh]

Hi Seshu,

Thanx for your quick response.

But here in my project we build only the universe(not the WebI).

Our task is to build universe using SAP BW.

As per your solution i think we can create uinverse on BEx query.

But does BEx support those many objects i,e as we require approximately

60-70 objects (viz. chars, KFs) into the universe.

Please reply.

[former_member199945]

It will support But Recomended is  MAX 50 Objects. Need to enable allow selection of structure members memebers in RSRT.

BEX query Through BICS connection ,Not OLAP Universe.

[deshmukh]

But here we need to create Relational Universe. can we acheive this?

Can you please explain in detail. I just started creating universes.

[former_member199945]

First check either need to create  Relational Universe / OLAP Universe .

Relational Universe ( SQL ) Doesn't support All BI Features where as OLAP  ( MDX ) will supports .

Refer Below Document in Google For details Steps For creating Relational Conn  on BI Infoproviders.

https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=5&cad=rja&uact=8&ved=0CEcQFjAE&url=h...

[deshmukh]

Hi Krishna,

We are also facing the above mentioned issue.

Please let me know how you solved it.

@ memebers please provide a solution.