Oracle Analytics and AI

User_G9FVN

Hi everyone,

I have some problem when design RPD file in OBIEE version 1.1.1.7.141014.

When I design a logical column with Descriptor ID:

When I create filter on Analysis. OBIEE show datetime picker for the descriptor id column instead of combo box for the Name column

This is what OBIEE show me (datetime picker for Descriptor ID column):

And this is what I actually want after setting up Descriptor ID column:

  Before setting up Descriptor ID column, the filter is combo box to select options for Name column, after setting up Descriptor ID column, I want the combo box stay the same, not date time picker for date type Descriptor Id column.

I don't know if this is a mistaken in my design or Oracle bug. Could someone explain to me?

StijnGabriels-Oracle

Hi,

I think you're making it too complex by using the Descriptor ID. I don't think you really need to use it.

You're already on the right track, but you should forget about the Descriptor ID on the Month Name. Just delete all that Descriptor ID stuff and use a 'plain' filter on Month Name.

If you have created a physical join between your Time (Month) Dimension and your Fact Table based on "Month End Date" = "Fact Table"."As Of Date"  the join will take care of filtering the fact table.

Regards,
Stijn