Error : Report between confirmed and non-confirmed dimension

Question

Hi Guys,

I have a scenario like below

F1 is joined to D1 and D

F2 is joined to D and D2

if i select columns from F1,D1,F2 in the analytics side..........its throwing an error

So,what my question is without throwing any error here,what i should do setting/chnages in BMM layer

could you please help me on that...thanks in advance.

Sherry George · Answer

Hi Pavan,

As Gianni already said, just set the content levels. If you still aren't getting the desired output something else might be wrong. But we cannot help without posting details.

Gianni Ceresa · Answer

PavankDatti wrote:you would have create fake join here between D1 and F2 and map to Total Level

No, a fake join is useless, content levels exist for something.

And if with "fake join" you think at a 1=1 I don't believe you really want a cartesian product between a fact with millions of rows and a dimensions that can easily have thousands of rows (or your DBA will soon call you to ask why you are killing his database).

Pavan kumar. · Answer

Hi,

you would have create fake join here between D1 and F2 and map to Total Level