I am trying to create a report that compares for example sales of various groups of stores. I have set up a data providor that retrieves the list of stores from excel and a second data providor that uses that query to then calculate the sales of the stores. I then use another 2 data providors to do this for another set of stores. (I know this is long winded but I need to perform calculations on the two groups so need to have them seperate). Anyway, when I do this, the list of store numbers then link themselves to each other and even if I unlink them they refresh and link back up. Meaning the results in the second set have the same properties of set 1. Not sure if that makes any sense, but does anyone have any ideas.
When you have multiple data providers, they are automatically linked on objects with the same name. If you modify the linking and subsequently modify any data providers, they again get automatically relinked on defaults
data providers do not automatically link when the object names are the same. The only time they do this is when the objects are the same objects from the same universe.
If, for example, you had a dimension called City in a spreadsheet based data provider and a dimension called City in a universe based data provider they will not automatically link
Lauryn… when you say the results in the second set have the “properties” as the set 1 results what do you mean ? I’m guessing the measure values are different but the list of stores is effectively union’d ??
I agree, they automatically link when they are from the same universe.
I beleive Jansi is using an excel data provider and multiple dataproviders from the same universe (as mentioned in her initial query).
And those are the ones that she mentioned are linking up automatically.
I have a report where the objects ARE linking and I don’t want them to. Refreshing the report does NOT relink them but I agree that it appears as if editing any of the queries causes them to relink.
Is there really no way around this (i.e. prevent the objects from relinking when the query is edited?)
Thanks!
no way to stop that…
I had at one point of time used a deski report with 20+ data providers. (yes u read it right 20 - and there were some objects (very few)
that I wanted to keep un-linked.
the work around I used was created copy of those objects in the universe as detail objects and used those in my query.
I’m also facing similar problem.
When I Unlink the dimensions and refresh the report it gives perfect data.
But when I schedule the same report on the server all the dimensions again get linked automatically.
Due to this after scheduling also , I have to retreive the refreshed copy and Unlink the dimensions again in order to get proper data…
Hi Chitra,
Before scheduling what if you make the data provider non editable ?
Does that still end up linking the objects after the schedule ?
What version are you on ? Wonder if it is a bug.
Vinesh,
Yes, that is what I meant, detail objects will not link and that is a work around I used in the past to save myself from the hassle of un-linking everytime I edit the report. I created a copy of the objects that I did not want to link and then later hid the detail objects.
Hi Naresh,
Thnx for reply…
I’ve already tried scheduling the rep after removing the editable option from Data Manager,but the problem still persists as the objects again get linked automatically.
I’m currently using BO 6.5 SP3 and will be migrating on XIR2 soon.
Also have already logged a call with BO for the same.
(BOB member since 2004-04-09)
(BOB member since 2008-05-12)
(BOB member since 2004-04-09)
(BOB member since 2003-04-15)
and there were some objects (very few)
(BOB member since 2008-08-20)