Problem in Linking Universe and Excel Dataprovider

building reports desktopintelligence
1

Hi,
We are using BO XI fullclient on Oracle.
I created two dataprovides -one universe (contains 10 objects)
one from excel(contains 10 columns); there is one common dimension
and i linked those two dimensions (same datatype-char)

when i click on one object of universe DP ,all the other columns in Excel DP are grayed out,excpet measures.

When i click on one column/object in Excel DP,all the other cloumns in universe DP are grayed out except measures.

I need to create a report ,5 columns from Universe DP and 8 columns from Excel.

I tried to change these object from Dimension to Detail and then drag it.
but no use.
How can i do this?? please help.

Anupama

mailanuv (BOB member since 2005-11-27)

2

Hi Anupama,

You cannot combine unlinked dimensions from 2 DPs in one table. The solution is to create a detail variable for each unlinked dimension from one of the DPs with the master dimension as the linked one.

You can then combine all of the dimensions and variables from the one DP with the linked dimension, the measures and the new detail variables from the other DP.

Steve

steveayres :uk: (BOB member since 2006-11-23)

3

hi

i am not sure but you can try this way.
go to view data-data manager->
link the objects from two different sources.
only unlink the date objects and see the results.

thank you
judia

judia (BOB member since 2008-06-24)

4

Anupama,

This Steve’s technique works I tried.

Rana :india: (BOB member since 2008-07-08)

5

hi pradip

can you please give an example with efashion universe?

thank you

judia

judia (BOB member since 2008-06-24)

6

Judia,

Try creating detail objects. I am attaching a word document where you can see the information about it.

Jansi :india: (BOB member since 2008-05-12)

7

Hi Steve,

Thanks for your reply.
I tried converting them to detail,but still i could not get the data from both the DPs,(objects are still grayed out)

And when i tried to convert the objects from excel DP to Measures , i was able to get the data from both DPs in one table.

Now the user has to check if the data is valid/correct or not.

Can we change the objects for Universe DP from dimension to detail/measure at the report level as we can do for EXCEL Objects at report level

Thanks For your help
Anupama

mailanuv (BOB member since 2005-11-27)

8

When you say you’re converting them, exactly what do you mean? You need to create Detail variables with the linked dimension as the master. You don’t change the actual object type.

steveayres :uk: (BOB member since 2006-11-23)

9

I mean, i changed from dimension to measure for objects from Excel DP.
i changed in view data-> (where we link the dimensions)

When i changed them to detail;The objects are still grayed out (from universe DP) when i click on any object of Excel DP

Thanks
Anupama

mailanuv (BOB member since 2005-11-27)

10

Do not change an object to detail. Just create a new detail object from that dimension.

Jansi :india: (BOB member since 2008-05-12)

11

hi jansi,
thank you very much for providing the document.
did you create the detail objects in the universe or in the report?

thank you

judia

judia (BOB member since 2008-06-24)

12

Hi Judia,

 Welcome. The answer is 'in report'.

Jansi :india: (BOB member since 2008-05-12)

13

hi jansi,

i created the detail objects for country ans sales person.
but i am unable to keep them in single table.

judia

judia (BOB member since 2008-06-24)

14

Are you associating this new object with the dimension object while creating it?

Jansi :india: (BOB member since 2008-05-12)

15

hi,

yes, jansi. i got the result. many thanks.

judia

judia (BOB member since 2008-06-24)

16

i tried as steve said: created detail variables and assoiciated them to related dimension and got the entire data in one report

but the problem is :even though all the columns data is displayed in one report,for some columns ,some rows ,data is empty(NO DATA)
and after some rows again data appears for those columns and in other columns some rows are empty.

but the rows/cloumns are linked (as i can see the same data from both the DPS in columns)

is it any join problem or am i missing something.

Anupama

mailanuv (BOB member since 2005-11-27)

17

Just to clarify, are you saying you have completely empty rows or just that some columns in the rows are empty?

If it’s the latter, it’s likely to be because one of your DPs has data and the other doesn’t.

steveayres :uk: (BOB member since 2006-11-23)

18

Data does not appear for some rows and Some columns.
To be clear: For Description column data appears for some rows and do not appear for some rows.
where as when i check the data for number/id and description in Oracle tables through TOAD, the data is available for all Numbers/ids and Desc.

I am not sure if this is a data load problem or
i am mising something at the report level.

Thanks Steve.

mailanuv (BOB member since 2005-11-27)

19

Can you attach a screenshot? It might make more sense and be easier to diagnose the problem.

steveayres :uk: (BOB member since 2006-11-23)

20

Hi Steve,

The screen shot is in the attachement.

Thanks
Anupama
Doc1.doc (174.0 KB)

mailanuv (BOB member since 2005-11-27)