cancel
Showing results for 
Search instead for 
Did you mean: 

WEBI Reports on BPC planning cubes

Former Member
0 Kudos

Hi Experts,

Could you please let us know if it is ideal to use the planning cubes(BPC cubes in BI) and create queries and universe upon them and then create WEBI reports on them . Have any one come across this requirement and created the webi reports using bpc data.

Would there be any complexities or performance issues ? Thanks in advance.

Regards,

Sanjeev

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Check my last reply on this post http://scn.sap.com/thread/1833417 , I hope it help you on what you need.

Regards,

Rodrigo

Answers (2)

Answers (2)

Former Member
0 Kudos

Check this out,


had a similar scenario and created reports successfully

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Yes, it is an increasing requirement.

it depends which version you are using obviously, but in BI 4.0 for example, you have BPC drivers/connectors in both semantic layer clients (Information Design Tool vs Universe Designer) , to connect to either BPC 7.5 or BPC 10, and for both BPC Netweaver (BW) and BPC Microsoft (MSAS) flavours, and using both MDX or XMLA interfaces.

As for "is it ideal?" well, "it is what it is" ... As a datamodeller, you will have to examine the structures of the BPC cubes, and from a reporting perspective, decide if these are appropriate in design. Sure, you can use them cubes "as-is", but they may not be 'optimized' for reporting use-case, so may require post-processing or staging into another target.

As for complexities? not really, but you cant' really plan for these , until they manifest themselves unexpectedly.

However, for example, i've heard of .UNV designers trying to create custom MDX objects with XML tags , and having a very hard time of it. (more so than a normal OLAP .unv)

regards,

H

Former Member
0 Kudos

Henry

    Is there a document that provides the best practices or recommendations when designing BPC cubes that are optimized for reporting purposes specifically for WEBI?.

Thanks

Nirmala

former_member188911
Active Contributor
0 Kudos

I am not aware of any document that specifically addresses WebI on BPC , generally speaking you would use the same approach as to any OLAP universe, please see this whitepaper http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/c0a45246-ce76-2b10-e688-f5c8206203eb&override...

best regards,

Simone

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Yes, i believe Note 1392259 is the reference you need

 

http://service.sap.com/sap/support/notes/1392259

Regards,
H