No fact table exists at the requested level of detail

Question

Hi All,

We store some additional work order data in DFF and this is loaded to our ETL tables.

But the additional details are maintained in the lookup tables.

For example: In Work Order DFF, we have got 'Released To' this indicates the line to which work order is released.

There is lookup for LINE_DATA. We store some information about the assembly line there. For example: - MAINTAIN_DATE.

In my RPD, in BMM layer I created table WORK ORDERS with WORK_ORDER,LINE_ID and MAINTAIN_DATE ( There are many more but these are key fields for this problem)

I established physical join LINE_ID from Work orders = LINE_ID in lookup table.

After RPD deployment, everything works very well exception of MAINTAIN_DATE.

When I try to add 'MAINTAIN_DATE to report I get following error -

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14025] No fact table exists at the requested level of detail:

I need some help to resolve this. This is the only thing which is stuck right now.

Does lookup work in OBIEE properly?

Thanks

user7638003 · Answer

Hello 1430724,

Please elaborate how you accomplished this issue? thanks

Md. Altas · Answer

Hi,

I was able to resolve this by using the lookups.

I used dense lookup and I get the MAINTAIN_DATE as expected.

Thanks

1036082 · Answer

Hi,

Please check in fact table whether all the hierarchies are added to the content level.

If not please set the content level.

Regards,

Venkatesh.