If you have only seen facts in the logical layer then it sounds like you are modelling 3NF. In the case of modelling 3NF the rule is that you model aliased tables to represent the physical tables, joining to represent the nature of the joins in the physical. When you model in the logical layer you turn the messy world of…

Sorry, overlooked your arrows, this is wrong!!! Table "B" --> Table "A" (Dimension) <-- Table "A"(Fact) It should be Fact -> A -> B in the physical And Fact -> A (with B subsumed via the logical join - see my 2 above) in the business model layer

Okay, two ways to deal with this. 1. Use the table as a lookup table, and model it as a sparse relationship, see -> https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-lookup-tables-sparse-and-dense-lookups/ 2. Model the snowflake structure by joining the additional table to the main table by dragging it onto the…

Hi, in business terms what are A and B; - a. Both dimension tables in a snowflake relationship b. Both fact tables c. Fact B and Dimension A d. Fact A and Dimension B Also, is this the entire picture, you are testing this without filters and without joins to other tables? Finally, you say; - Table "B" --> "Table "A" For me…

The best way of all to handle nulls in OBIEE is to get your ETL developers to turn them into something more useful. 'Unknown Gender' populated by the ETL for the null values will have less of a performance hit and will simplify reporting for everyone.

And prefix is only applicable to the 'nasty little analysis workaround' - I would recommend my rpd centric solution.

Hi, so you create two new dimension attributes in your rpd, 1. Is the original case statement 'Vesting Group' 2. Is the sort order column 'Vesting Sort Order' You then change the property on 'Vesting Group' for sort order to make it sorted by 'Vesting Sort Order' Then whenever column1 appears in any analysis it will be…

Yes, he will! In case (no pun intended) I was less than clear, I had meant to create a parallel column using the same statement but with numbers returned for the sort order, and then to use this on the displayed column with the original case logic. For the sort order column; - * CASE * WHEN…

Hi, the two comments are separate. If you make the case logic in the rpd then you don't need the prefixing, that was my comment for if you do not have access to change the rpd and can only make the case logic in the analysis, there I was suggesting that by making your prefix on the column give you the right order it was a…

Hi, if you can have the case logic in a dimension in the rpd then you can also apply sorting based on another column. Not sure if there is anyway to achieve this with column selector that is 'pure' analysis based solution otherwise, other than prefixing your column with A. < 1 Years, B. 1-3 Years etc...

'almost'? What is different to make you say almost? Does one have explicit filters and the other respond to 'Is Prompted' and / or have 'Prompted' sections in its presentation?

With just a table / pivot table or similar and no other views presented in a compound analysis / dashboard page?

Probably this => Display custom message in No Results view in OBIEE - BIFuture.com

Have a look at this, you have missed a step; - Oracle Business Intelligence OBIEE 101: OBIEE Executing your own JavaScript

There is no standard solution for this, you would need to use javascript to resolve this. There are a number of hits on this => https://www.google.co.uk/search?q=OBIEE+clear+prompts+using+jscript+on+change+of+other+value&rlz=1C1GGRV_enGB768GB768&oq…

The latter of your two attempts, definitely NOT the function palette!! I usually convert filter to SQL and then do this.

Is your issue resolved or do you need more help on this?

Hi, try a case statement on the filter so when your default {AllValues} is selected it does the equivalent of 1=1 on the filter case when @{PresentationVariable} = 'AllValues' then TheColumnBeingFiltered else @{PresentationVariable} end = TheColumnBeingFiltered Btw - did you abandon the other questions from yesterday - it…

Like this? If so, achieved by ticking totals after for Accounting Year and then totals after for rows (the sigma tick)

Assuming tabular analysis in the results tab / layout you can set Total After on columns and measures; - Click on Format Labels; - Make the caption what you need.