Error : Report between confirmed and non-confirmed dimension — Oracle Analytics

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error : Report between confirmed and non-confirmed dimension

Received Response
1
Views
5
Comments
3231180
3231180 Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

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.

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi,

    Please post the error you are receiving. I'm taking a guess here. You may not have set the levels properly. Since F2 is not joined to D1, the F2 measures should be set to Total level of D1 dim.

  • Gianni Ceresa
    Gianni Ceresa Mod

    First thing: conformed dimension. I hope all your dims are confirmed or I would ask you what they do there if nobody confirmed they want these dims.

    3231180 wrote:my question is without throwing any error here

    Is that a test? What do we win if we answer right without having anything as input?

    I would bet on a wrong configuration of the content levels, this one match 98% of the questions with conformed dimensions.

    But of course can also be the database being down, the column name spelled wrongly or any other random error message you maybe had on your screen.

  • Pavan kumar.
    Pavan kumar. Rank 5 - Community Champion

    Hi,

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

  • Gianni Ceresa
    Gianni Ceresa Mod 
    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).

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    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.