Merge dimens

[former_member402770]

Hi,

  I have my below merged dimensions named as "Merged Dim" from 3 Bex and 1 Universe data providers  in my report.

Merged Dim

query 1

query 2

query 3

univ  1

Now Iam looking to display reports in one tab as Bex report and another tab as universe:

Tab 1:

Merge dimens(query1+query2+query3)     sales amt

Tab 2:

univ1                                                  sales amt

Iam struck here as i have already merged bex and universe. I want something like bex alone merged dimens and shown in tabs. Could you help in creating the Merge dimens (query1+query2+query3) ?

Thanks,

Dinya

[amitrathi239 · Accepted solution]

Hi,

right click on the merged dimension and unmerge it.

After that select objects from three BEx queries and merge it.

Amit

[former_member402770 · Accepted solution]

Amit,

Thanks for your quick reply again.

I have three tabs one is i need to show bex reports alone it is a combination of three queris Merge(dim1.query1+dim2.query2+dim3.query3)

2nd tab - Ora Universe (dim1.univ1)

3rd tab - Bex+Ora Merge(dim1.query1+dim2.query2+dim3.query3+dim1.univ1)

i started in 3rd tab to build the report apply merge on  common dimensions  but 1st tab is reusing the common dimension of 3rd tab except dim1.univ1.

so what i would need to display in firts tab is an Merge(dim1.query1+dim2.query2+dim3.query3). If i unmerge the merged dimens, the 3rd tab will also become unmerge as it is using the same dimens

Thanks,

Dinya

[amitrathi239 · Accepted solution]

Hi,

try something like..

Var=if(merged object=Uni.object) then "Hide" else "show"

make Var variable as measure.then apply the report filter on Tab 1 where Var is equal to show.

with this you can exclude the values from universe object.

if above one will not work then try with this.

Var1=if(not(isnull[uni.object])) then "Hide" else "show"

apply the filter in tab 1 where var1 is equal to show.

make it measure variable.

Amit

[former_member402770 · Accepted solution]

Amit,

Thanks, but not sure why we have to use measure object variable here.

Thanks,

Dinya

[amitrathi239 · Accepted solution]

Hi

can an you explain your question.

with above formula your requirement will meet..

use merged object in the first tab however you need to display only data from BEx queries.so with variable you can exclude universe values.

WIthout merged object you can drag objects from only one query.from second you cannot drag in the one table until object is merged.

Amit