Hi Experts,
I have created a formula in the analysis like below
COUNT(Orders BY Segment, Year)
Can I incorporate the above logic into logical column in bmm layer?
Thanks
Assuming Orders is a measure and you have the proper hierarchies defined for those 2 dimensions, you can create a level based measure that will give you what you want.
https://gerardnico.com/wiki/dat/obiee/obis/measure_level_based
Pedro,
Thanks for the reply. In my case, all the columns are coming from one dimension table. May be I have to separate them into different logical fact and dim tables and then create the level based measure.
But can I create one measure at different levels i.e segment and year?
Whilst you can 'pin' a measure to as many dimension hierarchies at whatever level you need I would caution that you may find that the numbers may not be correct if you have a dynamic data population.
i.e. if you form has prompts/ filters you may find that the level based measure does not produce the right figures, but your analysis based count by will.
Others may have found ways around this, but this has been my experience in the past when I was trying to create share of segment, share of market measures which dynamically restated based on the current total data population driven by prompts and filter functionality.
In short, try it, but do test heavily on a number of scenarios before relying on it in a production environment - which should be the caveat with all BI functionality.....
You could use the EVALUATE_ANALYTIC function in RPD. Give it a try.
https://www.rittmanmead.com/blog/2010/10/oracle-bi-ee-11g-calling-database-analytic-functions-evaluate/
3547198 wrote:Thanks for the reply. In my case, all the columns are coming from one dimension table. May be I have to separate them into different logical fact and dim tables and then create the level based measure.
Remove the "maybe".
The logical model is supposed to be a real model, a start schema. If all the columns come from the same table doesn't matter, that's a detail for the physical layer. In the logical layer they are supposed to be dimensions (and segment and year are generally 2 different dimensions).
In that case, with a proper model, you can then add all the level based measure you want mixing all the required granularity and dimensions.
Thanks for the reply Gianni. Will give a shot at it.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
