Drilling with multiple data providers

building reports desktopintelligence
1

Has anyone encountered problems using drill mode when more than one data
provider is used in a document? We built a report tab using a single data
provider, and drilling works fine.

Adding another report tab with an additional provider produces inconsistent
results in the 1st tab, even when the hierarchies in both are fine.

Any insight on the problem here? thanks,
Ralph Chapman
Sandia Labs

Listserv Archives (BOB member since 2002-06-25)

2

Ralph wrote:

Has anyone encountered problems using drill mode when more than one data
provider is used in a document? …

I have several reports that have multiple data providers that are linked.
Each data provider may have its own default hierarchy based on the order of
objects in the universe. Therefore, the report may have multiple
hierarchies, and when you drill down through one hierarchy, you may then go
into the other hierarchy. What I have done to alleviate this problem
follows. After the report is done, I refresh it and go into the hierarchies
and delete the extra hierarchy. I then refresh the report, and the extra
hierarchy is gone.

Note: If I change the universe at all after this, I need to reopen the
report, refresh it, remove the extra hierarchy, refresh again and save the
report.

This is rather unwieldy, but I haven’t gotten any other suggestions on how
to handle this.

I hope this helps.

Marian Cooney
McKesson HBOC
Malvern, PA

Listserv Archives (BOB member since 2002-06-25)

3

Ralph,

Check and see if your data providers are linked together. If both data
providers
have the same dimension, BusObj will automatically link the two
data providers. Check in the DataManager for linked objects…

Jeff Moore
Electronic Data Systems

-----Original Message-----
From: Chapman, Ralph [SMTP:rlchapm@SANDIA.GOV]
Sent: Wednesday, April 21, 1999 2:55 PM

Has anyone encountered problems using drill mode when more than one data
provider is used in a document? We built a report tab using a single data
provider, and drilling works fine.

Adding another report tab with an additional provider produces
inconsistent
results in the 1st tab, even when the hierarchies in both are fine.

Any insight on the problem here? thanks,
Ralph Chapman
Sandia Labs

Pls report bounces in response to postings to
BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in
BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================

Listserv Archives (BOB member since 2002-06-25)