Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to create one measure in logic layer
Answers
-
Hi,
No, I was seeking to refine 'our' thinking into discrete 'packages', partly to ascertain that I had understood your requirement coŕectly, partly to break it down into discrete elements.
I can envisage a number of ways this is achievable in an analysis, using one analysis as the filter for another immediately comes to mind, or sql in the filter, or using the filter functionaly to get it KPI style...
But the 'having' clause and the time frame would seem to preclude getting it in a single step for a measure without resorting to an opaque view, materialzed view or similar ETL precomputation to replicate your sql logic, but then it would have to be for a consistent timeframe.
0 -
Hi Robert,
The data is not calculated in summary table as before, since when uses select multiple date, the result for counts=1 did not be summarized(It will be calculated repeatly).
0 -
That is why I commented - 'it would have to be for a consistent timeframe' - i.e. you can only do this for a day / week / month as a pre-computed measure because of your 'having' clause and the fact that you want the sum of 1.
I had a similar requirement once with share of market / share of measure for a dynamic population and the bottom line is that with BI you can not do it wholly with the measure between of the non-fixed population that you are running the underlying logic on.
0 -
So if you can redefine the requirement to a finite set of fixed measures then it is achievable.
Or you can construct it in an analysis it is achievable.
The only other way I can think you could do this is by refreshing a table content at the back end database when they invoke the report - which seems excessive to say the least for one measure.
0 -
Just plane hopping, but.....measure content levels....
0 -
Sure, BUT, remember the having 1 clause for a dynamically determined period, this is not down to measure levels - though I get where you are coming from, but I am equally certain it would not work this time....
So; - Of this population of 1 in Time from X to Y, how many?
NOT - pinned to a day / month / year, unfortunately!!!
0 -
Well for the rest you do need the forced dimensionality and granularity
0