Drill Down and Drill UP

building reports webintelligence
1

Hi ,

Currently we are facing the problem while we drill down and drill up the the dimension objects, When we click the drill down or drill up the current dimensions the next level object showing two times. Could you please help on this issue.

Note: we are using 5 dataprovides and same kind of other reports are working fine with out any issue

Thanks,
Drill.doc (173.0 KB)

svsenni (BOB member since 2005-04-28)

2

Could it be that as your queries are merged, it is showing the merged objects and not just the next objects in the up/down drill path?

Xavier :ireland: (BOB member since 2006-12-18)

3

Hi Ya,

I have merged all the possible dimension object.

Thanks,
Merge.doc (63.0 KB)

svsenni (BOB member since 2005-04-28)

4

I don’t think this is a problem. I think it’s normal.
If you have merged the data providers then the report needs your response to know which query to drill through.
I don’t think it is good practice to drill from within a merged query. Your results could go easily become non-understandable

Xavier :ireland: (BOB member since 2006-12-18)

5

Hi Ya,

We don’t have other options other than merge dimension the reason is our Data model is not supporting to combined queries.

Please advise me.

This is our major issues facing in UAT.

Thanks

svsenni (BOB member since 2005-04-28)

6

Another option might be to use Data Federator.
This way you could ‘virtually’ merge the data at query time, and present it as a single report

Xavier :ireland: (BOB member since 2006-12-18)

7

Hi Xavier,

I am not aware of Data Fedarator, could you please share me how to do.

Thanks ‘N’ advance,

svsenni (BOB member since 2005-04-28)

8

it’s another BusObj application. This link should take you to the SAP site
http://www.sap.com/solutions/sapbusinessobjects/large/information-management/data-integration/datafederator/index.epx

Xavier :ireland: (BOB member since 2006-12-18)

9

Hi Xavier,

Currently i can’t use other bo application in our current environment, this we have to get lot of approval.

Now i will be in big trouble if i am not solve this issue.

I will try best thanks for your help.

Thanks,

svsenni (BOB member since 2005-04-28)