SAP BI - BO Integration

[Former Member]

Hi

I have created Business Objects OLAP universe (BO XI 3.1) on SAP BI(7.0) cube Profit Center Accounting

I have done check integrity in OLAP Universe. It is parsing all objects with no error.

I have developed a Webi report on SAP BI OLAP Universe and trying to

create hyperlink report thruu2019 the hyperlink function available in Webi 3.1

I have created Webi Report 2 on the objects L01 Profit Center , L02 Profit Center , Cumalative Balance with the Prompt Value on L01 Profit Center.

I have exported report to Repository.

I have created webi Report 1 on the objects L01 Profit Center , L02 Profit Center , Cumalative Balance

I have exported report to Repository.

From Infoview in report 1, I am trying to create a hyperlink on L01 Profit Center object to call report 2 assigming the prompt value in report 2.

But getting below error.

A database error occured. The database error text is: The MDX query SELECT { [Measures].[0CREDIT],[Measures].[0DEBIT],[Measures][0BALANCE]} ON COLUMNS, NON EMPTY HIERARCHIZE (UNION ( { [0PROFIT_CTR CR01INFI].[Northern Region]},{Descendants( { [0PROFIT_CTR CR01INFI].[Northern Region]},[0PROFIT_CTR CR01INFI].[LEVEL02])})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS FROM [$0PCA_C01] failed to execute with the error Unkown error.(WIS 10901)

I have tested same hyperlink function in webi 3.1 on efashion universe

(Sample non OLAP Universe) and its working fine.

Can you please guide us how to solve this issue?

Thanks & Regards,

Vrushali

[Former Member · Accepted solution]

HI Vrushali,

Could you please help me with the steps you followed to Integrate SAP BI7.0 with SAP BO XI3.1 as I'm BI consultant and new to BO.

Regards

Ajay

[IngoH · Accepted solution]

Hi Ajay,

don't post the same question several times. You already received answers.

ingo

[former_member539471]

vrushali,

You seem to be ahead of where we are in my project in BO-BI integration.

I have a few questions and problems that we can anticipate going forward in this. it would be great if you share any information.

Like ....

1. did you create any reports on BI -cube any limitations, work arounds for problems encountered.

2. i created a calculated measure in universe and exported the universe, in webi i got a database error.

3. all the calculations are done in BI query, but if the datasource is a cube, how do i do all those calculations which i would have done in query designer if created.

How do i accommodate calculations in BO universe if the source is cube?

4. MDX syntax, where can i look for mdx syntax for SAP

Your help is greatly appreciated

Thanks

[IngoH]

Hi,

1. did you create any reports on BI -cube any limitations, work arounds for problems encountered.

limitations listed here:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/008d15dc-f76c-2b10-968a-fafe5a12...

In addition you can not use authorization variables.

3. all the calculations are done in BI query, but if the datasource is a cube, how do i do all those calculations which i would have done in query designer if created.

>> You have to build them yourself as calculations in the universe.

How do i accommodate calculations in BO universe if the source is cube?

4. MDX syntax, where can i look for mdx syntax for SAP

>>https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c82062...

[Former Member]

Hi Vrushali,

Are you able to fix the error which you had while writing calculated figure.

Please share the solution.

Thanks,

Krishna

[IngoH]

Hi,

you need to make sure that you are sending the key value from the profit center to the prompt because the description is not unique

Ingo

[Former Member]

Hi Lngo,

I have a "Region" in L01 profit center object and "State" in L02 Project center Object

In report 1, I have taken 2 Objects L01 profit center(Region) and cumulative balance (Balance key figure)

In report 2, I have taken 3 objects L01 profit center(Region) , L02 profit center (State), cumulative balance (Balance key figure)

My Objective is from Report 1, I should able to link report 2 with Region (L01 profit center)

means If I click on Northern Region in Report 1, I should able to pass Northern Region to report 2 and Report 2 should display me data for Northern region.

In report 2 I have created prompt on L01 profit center(Region) , So how can I pass Key Value to Prompt ?

I am clicking on Northern Region , so its passing unique Value , I am not sure How it is taking multiple Values ?

Thanks & Regards,

Vrushali

[IngoH]

hi,

you passing in the description and not the key. "Northern Region" could be a totally different description in language DE, JP, FR. You need to use the key values. Each characteristics in the universe also has a key value.

ingo

[Former Member]

Thanks so much Ingo, It's working fine with Key Value.

Can you please help me for creating the OLAP universe objects.

1) Last year fiscal period

2) Year to Date - current fiscal year

3) Year to date - Last year fiscal period

MY requirement is user can supply the Fiscal Period example - MAY2009 then My report should display the data for

1) Last year same fiscal Period ( e.g. MAY2008)

2) Year to Date - current fiscal year( e.g. APR2009 to MAY2009)

3) Year to Date - Last fiscal year( e.g. APR2008 to MAY2008)

My Fiscal Year start from APRIL to MARCH each Year.

Thanks In advance..

Thanks & Regards,

Vrushali

[IngoH]

Hi,

to create custom objects take a look here:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c82062...

Or you are using EXIT variables in the BW query to to this.

Ingo

[Former Member]

Hi Ingo,

I have created the YDT object as

<EXPRESSION> SUM(YTD([0FISCPER].[LEVEL01].CurrentMember),[Measures].[0BALANCE]))</EXPRESSION>

But when I used this object in WEBI report its giving me below error

Query 1 - Profit Center

A database error occued. The database error text is: The MDX query WITH MEMBER

[Measures].[AACACDA8-4D25-4D5A-B0,E2,486,C3,D5,97,95]as' SUM(YTD([0FISCPER].[LEVEL01].CurrentMember),[Measures].[0BALANCE]))' select {[Measures].[AACACDA8-4D25-4D5A-B0,E2,486,C3,D5,97,95] } ON COLUMNS, NON EMPTY [0PROFIT_CTR CR01INFI].[LEVEL00].MEMBERS ON ROWS FROM [0PCA_C01] failed to execute with the error Unknown error ( WIS 10901)

Can you please guide me.

Thanks & Regards,

Vrushali

[IngoH]

can you run the MDX statement in transaction MDXTEST ?

thanks

Ingo

[Former Member]

Hi Ingo,

I executed the following statement in MDXTEST.

"SUM(YTD(0FISCPER.LEVEL01.CurrentMember),Measures.0BALANCE))"

Its throwing the following error.

Invalid MDX Command with SUM

Pls help me.