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.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
