Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

converted to NULL because its grain is below query's grain.

Raghavendra Hari Nakka-OracleApr 22 2014 — edited Apr 22 2014

Hi ,

I joined the Fact and Time Dimension with AccountingPeirod( eg: 'MM', 'QQ' , 'MN' ) and Year column means two join conditions.The grain of Time Dimension is at month level.Month is rolled up to Quarter and so on.

I created Timeseries measure Previous year Amount and when I ran the this in Analytics it gives null results and when I check the view log file it says " converted to NULL because its grain is below query's grain."

Anybody has correct answer do let me know at the earliest.

regards

Raghav

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2014

Added on Apr 22 2014

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

355 views