Conditional formatting fact columns

3427784

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.

Thomas Dodds

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)

3427784

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'.

[Deleted User]

"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".

Gianni Ceresa

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).

Rohit Trehan

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"

[Deleted User]

It's Friday night. My wording may indeed be bad

Gianni Ceresa

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 ...

Thomas Dodds

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 ...

3427784

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!