OTBI - The specified criteria didn't result in any data. when adding department under workforce mana

King Jack

Content

Hi,

I've added the columns I need from the WORKER folder and the result come back nicely. As soon as I add a column from any other folder, no results are brought back.

I am in the "workforce management - worker assignment real time" subject area

Why is this happening and what can I do to resolve this issue?

Thanks,

JJ

Christian Berg

The RPD is messed up and since it's OTBI you can correct the mistake yourself.

Open a Service Request

RichardChan

You have a join or level issue in your RPD,

What granularity are your columns, can you be more specific with what columns are being added. Check you have set up joins between these data items and have set up your levels correctly, if necessary set Fact levels to "Total" level to bring in the data.

Are you in this situation : https://www.kpipartners.com/blog/bid/83120/What-To-Do-When-OBIEE-Fact-Tables-Do-Not-Join-to-All-Dimension-Tables

https://greatobi.wordpress.com/2011/06/24/making-dims-facts-work-together/

 

Richard

King Jack

• I am in the "workforce management - worker assignment real time" subject area
• I add person_number from WORKER on its own - brings back everything
• I add department level 3 from DEPARTMENT > HIERARCHY on its own - brings back everything
• I bring back both - it brings back nothing

Christian Berg

Yes and that points to an error in the RPF concerning non-conformed dimebsionalities which is why Richard wrote that explanation.

But since - iirc - you can not change the otbi rod yourself you can bot fix it yourself.

If you can change the otbi rod then all the better and you can eliminate it.

Alterntively you can add the following to the analysis in the advanced tab:
SET VARIABLE ENABLE_DIMENSIONALITY=1;
But beware - that is a CHEAT and not a fix!