nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

RPD -- BM and Mapping:- Data not displaying on Analysis

Rai Qaiser Hussain

Hi All

In Business Model and Mapping there are two fact logical tables and many dimensional, as you can see in below Figure, I have written below statement in field of F2 Lab Revenue which is also highlighted.

I have a requirement to show LAB revenue separately, Total Cash Amount contains cash of every department, after adding case system should return cash of LAB only but it returns the zero amount --- data at db exists

CASE

WHEN "Revenue"."D04 Department"."Department Id" ='0010100' THEN

"Revenue"."F1 Revenue"."Total Cash Amount"

ELSE

END

BD- Field Referred from another table.jpg

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

What did you do to debug and find where is the issue?

Did you look at the logs to check the generated query and understand the reasons of your results there? Did you changed your model/formulas as required based on the analysis of the query?

Rai Qaiser Hussain

I have not checked the logs (infact I don't know how to check the query in BI Administration, query during analysis (Advance tab) was very simple which could not help me), I am creating new model as Lab Revenue

[Deleted User]

Let me ask the obvious question here once: Did you ever get a training for OBI?

To be blunt - you won't be able to do a good job just by winging it and asking questions on the forum. You'll create more longterm issues than solve problems or benefit your client / employer.

Rai Qaiser Hussain

Hi @Christian Berg

Yes I got training few years back but started working now. I don't know why you commented last line but I assure you that everything will be fine.

Soon I shall help to others on same topic as you people are helping me now a days

[Deleted User]

Rai Qaiser Hussain wrote:I don't know why you commented last line

Maybe to make it clear that complex topics can't be just "done like that" and many companies go down that road because they don't believe in spending money on training. Which is pretty much a death sentence for getting value out of what you're doing.

Producing "something" isn't hard. Producing something correct, pertinent and which is adding value is harder.

Rai Qaiser Hussain

nice advise

Thomas Dodds

why does your image show a separate logical fact but your case statement is reflecting another logical fact?

Rai Qaiser Hussain

Hi @Thomas Dodds

I have fixed this problem, thanks for the comments

Gianni Ceresa

Rai Qaiser Hussain wrote:Hi @Thomas DoddsI have fixed this problem, thanks for the comments

So you can “give back” to the community forum by posting how it has been solved and by closing the thread marking things as required. That’s how a community forum works: never too early to give back and not just take...

Rai Qaiser Hussain

There was not a solution at all, it was a very basic mistake at model and data level which identified with continuous efforts, original field type was character with data 0010100 but during modeling mistakenly it was converted to number, starting '00' was truncating that's why CASE Statement was returning 0 amount instead of Total Cash Amount. Tested with first logical fact.

this dimension was already exists in RPD but not in use and I was not expecting such basic mistake, first I tried many time with different techniques then posted at this forum --- really sorry for wasting the time of community fellows.