Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Conditional formatting fact columns
Good afternoon,
I have a table in BI that looks similar to the one below.
My goal is to create a conditional format so that if the FACTS table for McDonald's and Burger King are equal to one another, it will be color coded green. It will return a red color if the numbers are not equal.
I have read about using Bins and creating a repository variable in the RPD to achieve this, but was wondering if anyone had a different avenue for a simple conditional format solution for this specific problem.
Thank you all.
Answers
-
what about setting the target at the yearly average ... then compare to target ... if they both are equal and there's 2, then they are at the average (and green)
0 -
The numbers were just an example -- I was expecting OBIEE can execute conditional formats against 2 fact tables e.g. 'FACTS.McDonalds' = 'FACTS.Burger King'.
0 -
"2 fact tables" - I think you're not being clear with naming and what's what here. What do you call a "fact table"? Because "Facts.McDonalds" means "column named McDonalds residing in the fact table named FACTS".
0 -
In addition to what Christian said (so bad wording), do you really have "Burger King" and "McDonalds" as columns in your fact table? In theory they are supposed to be attributes, so in a dimension and then you have unique measure from your logical fact table representing no idea what your numbers are supposed to be (average number of burger sold by minute or something ...).
If you do not provide some insight on your model it will be difficult to give you precised answers (and Thomas already gave you an idea as long as you match the "if" he sets).
0 -
Here is the solution:
1. Create an additional column with the formula:
case when "FACT.measure1" = "FACT.measure2" then 1 else 0 end
2. Lets call the column 'dummy' and Hide the column
3. Go to the conditional formatting for "FACT.measure1" and select 'dummy' =1 then 'Green'
4. Go to the conditional formatting for "FACT.measure1" and select 'dummy' <> 1 then 'Red'
5. Do the same for "FACT.measure2"
If it resolves it, please mark as "resolved"
0 -
It's Friday night. My wording may indeed be bad
0 -
I was referring to "his" bad wording with "2 fact tables".
And for the architect: yours can be a solution assuming he has 2 real measures, something that a normal common standard model will not have ...
0 -
It can ... you just have to model it correctly ... that being said ... I'll echo what the others have said - more info from you is needed. Perhaps post a diagram of your logical model ...
0 -
obiee_architect --
Thank you this is precisely what I was looking for. I knew some manipulation needed to be done and you routed me to the right direction for this novice OBIEE user. To everyone else, thank you for your insight as it helped me understand my question more and will do my best to explain clearer in the future when posting questions.
Thank you!
0
