Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 21, 2013 2:24 AM by
Repository Based Measure Aggregation - 1 out
Feb 21, 2013 2:24 AM
I have a base measure; case when meas.identifier_id =1 then m.unique_id else null end
On this base measure I create an aggregation at Total level for a dimension Taxonomy.
When I present the value of the total level aggregation against an in analysis sum(base measure) the two values are one different, with no parameters.
Now this is only 1 out of millions, but even so I want to use this value to calculate % of values - and as such it will cause my results not to come back to 100%.
My base measure is an integer and my client's version of OBIEE in this instance is 220.127.116.11.0
Any suggestions what to look at that could be causing this?
Would one value having a null taxonomy dimension member be a possible cause? (There is only one member in the presentation layer of this dimension)
This content has been marked as final.
Show 0 replies