Skip to Content
author's profile photo Former Member
Former Member

SAP BI - BO Integration

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2010 at 01:33 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 23, 2009 at 03:34 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 16, 2009 at 11:48 AM

    Hi Vrushali,

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

    Please share the solution.

    Thanks,

    Krishna

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2009 at 02:55 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.