Mulltiple cubes in DeskI data manger

building reports desktopintelligence
1

Hi,

I am having a universe called ‘A’. I have added a table in to the universe and joined to the existing table as per the requirement. When i drag the objects from the newly added table it is giving me 2 select statements in deskI sql and not only that in my data manager my universe got splitted in to 2 like A.cube1 and A.cube2. I didnt understand why it got splitted in to 2 cubes. Please help me on this…
After reading the posts i have done the following:
-unchecked multiple sql statements in Universe designer.
-Tried to solve this by adding contexts and also alias tables.
But no use, Can anyone please help me to solve this issue.
I am using BOXIR3,Deski and the DB is oracle.

Thanks,
Ashie

Ashie :india: (BOB member since 2008-09-17)

2

Moderator Note: Please do not cross-post. It leads to fragmented discussions and is against our forum rules. Carry on here. Locking this now.

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