Categories
- All Categories
- 146 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
function absolute in calculated item
Answers
-
How about Column's data format?
0 -
Take a step back and explain in detail. "Plan" and "Real" are members in a dimensional attribute is that it? Are you using an Essbase cube as a source?
0 -
It's an external db source related to Essbase. These are my columns. Location contains "Plan" and "Real". I want to obtain the percentage difference between Plan and Real from the same month.
0 -
3689512 wrote:Documentation says yes but havent managed to make it work
Do you mind to post a link to this?
Every place where OBIEE support functions has the "f(...)" button, the calculated item doesn't have it and just provides few buttons for basic operations, so I wouldn't expect functions to be supported there.
0 -
-
What version / tool are you using exactly? (the doc begin a BICS doc I'm trying to figure out what exact version and tool you are using )
0 -
Oracle Business Intelligence 12c (OBIEE)
0 -
So ...
The doc says the same even for 11.1.1.9, but doesn't provide any example of how to write those 5 functions. Couldn't find a way to make it work.
Found a reference of somebody else asking the same on Stack Overflow but had no answer.
So .... no idea how it's supposed to work
Maybe worth to ask in before to open an SR to get an "official" answer.
0 -
True, calculated items don't support the normal ABS(...) for absolute.
However the problem you're facing comes from several things
a) an Essbase derived source
b) without a scenario dimension
So the issue is a modeling issue at its base for which the solution of "$" isn't the best one.
If you put things into a formula it becomes more complex but it's doable by deriving proper *measures* from your structure. Again, the solution would be to switch to a different source model which either contians the scenarios or doesn't store the measures as dimension members!
FILTER("SomeMeasureTable"."IMPORTE" USING "SomeDimensionTable"."LOCATION"='Real')
FILTER("SomeMeasureTable"."IMPORTE" USING "SomeDimensionTable"."LOCATION"='Plan')
and then you can calculate the Variance
(FILTER("SomeMeasureTable"."IMPORTE" USING "SomeDimensionTable"."LOCATION"='Plan') - FILTER("SomeMeasureTable"."IMPORTE" USING "SomeDimensionTable"."LOCATION"='Real')) / FILTER("SomeMeasureTable"."IMPORTE" USING "SomeDimensionTable"."LOCATION"='Plan')
0
