Hi, on your requirement the only way I can see that you could achieve this is by calling a database function written for the purpose. Not good, not performant, not standard, not recommended. Could you use SUM ( YourMeasureHere by Id ) - to achieve your ends?

Hi, the docs note this; - An action link or conditional action link that is on a displayed total or grand total will not pass a parameter outside of related BI content. I don't think you can get around this without a fairly extensive workaround, like using a union query to create what looks / feels like a total row, but…

re: Hints - I tend to be a busy man, hence some of my helps are laconic bordering on one word. Also, I figure this is a help forum, not a training forum, so I expect foundation OBIEE skills as a minimum, and where this is obviously not the case will advise OBIEE by Example and other trainings, free or otherwise. No offence…

HI, Temoryian, this is a hell of a piece of work to come to OBIEE as a newbie to! I am curious on 'Hyperion is coming to the end of its life' - you might want to get your organisation to look into PBCS https://www.oracle.com/uk/applications/performance-management/products/planning-budgeting-cloud.html - Hyperion lives on…

Hi Leslie, from memory I think there is also a wizard in the rpd that lets you change all occurences of tableX to tableY (Or MatViewY in your case)

Hi, Christian is (as always) completely correct. Your snapshot from the MV will be seen as no different to a table, just import it in the usual way into the physical layer, join it to the appropriate tables (aliasing first for best practice) and then remap the columns onto the business model to replace all fields with the…

Hi Gianni, if the edit was aimed at me then no need, I am 'bigger' than the points awarded herein, if you take the gamification seriously then you have probably forgotten why you started playing the game... if it was aimed at others then; - "Honi Soit qui mal y pense" And I know exactly what you mean on the case statement,…

The syntax of your case in OBIEE is not correct, you only need one case statement, see -> https://gerardnico.com/dat/obiee/obis/logical_sql/case Also, ideally your quarters should be part of your time dimension and populated by your ETL - time dimension is a cornerstone dimension for me, if that is sub-optimal then it will…

No there is no alternative within OBIEE itself. You might want to have a look into using Apex as better tool for capturing comments in conjunction with OBIEE.

3 lines? 1. Define what you need and what you will need in the foreseeable future 2. Hire a decent architect to design a solution based on your requirement 3. Refine the solution until you can live with the cost and the compromise I fear however, that companies that specialise in cheap as chips BI are gaining market share…

Have you tried following => BIEE 11g|12c: How To Change The Default Dashboard Or Start Page for A User Programmatically (Doc ID 2151119.1) https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=431890668324148&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id…

Best advice, check all possible points of failure. 1. Put your diagnostics up to max, run your analysis, check the physical sql generated, does it contain the extra logic in the where clause? 2. Check the roles and groups associated with the user - are they what you expect? Also, did you apply the filter against the fact…

Is there any kind of security that could be blocking the socket in question?

Also, if Dim Person has more than one person per person id then that is the least of your problems. You need some kind of SCD functionality to make your employee 1:1 in all time periods, unless you are saying that the result you posted previously would work if you had made it; - Period / Employee / Age??

Sure; - case when 'WhateverConditionYouNeedHereIsTrue' then your FormulaHere else 0 end Make the aggregation on it sum.

What aggregation rule do you have on that column, and what data type?

Hi, as below, tick the box for derived from physical mappings (as opposed to 'Derived from existing columns' which is a logical calculation) and then use the mapping to create the measure logic; -

Did you try in rpd as physical as opposed to logic column?

Try checking 'server complex aggregate' on the formula column in question. Failing that, as Thomas correctly says your only recourse if that does not work is to calculate in the rpd using a physical formula - the problem is when OBIEE tries to aggregate, typically it will try to aggregate first and divide second - which is…

On a temporary work around - it will not be as performant - you can create a calculated physical member based on your original in the rpd and replace your current measure with the calculated equivalent.