Aggregate on 0CALMONTH

[chris_robertson]

We want to create an aggregate that includes 0CALMONTH. But when I pull OCALMONTH into my aggregate definition it also brings in 0CALDAY, which defeats the goal on our aggregate.

Is it possible to create an aggregate to include the month without pulling the day into the aggregate?

Thanks,

Chris

[Former Member · Accepted solution]

After the system inserts 0CALDAY automatically with 0CALMNTH in the Aggregate, take it off and activate Aggregate.

Ignore if there are any warnings.

[chris_robertson · Accepted solution]

I removed it and it adds it right back in. Log says 'Calendar Day' transferred because of exception aggregation for 'Calendar Day'

[Former Member · Accepted solution]

Have you modifed 0CALMONTH? Please compare Active version and Content version and post if there are any differences.

[former_member188975 · Accepted solution]

Hi Chris,

My guess is that one of the key figures in your InfoCube uses Exception Aggregation by 0CALDAY (you can check this in RSD1), and since you cannot make a choice for key figures in aggregates, I am not sure how you can get rid of 0CALDAY...

[chris_robertson · Accepted solution]

Thanks Bhanu. That's appears to indeed be our problem. There is key field using exception aggregation by 0CALDAY.

(Sorry, I was going to award points and close this out. But, I'm not bright enough this mornig to figure it out.)

Message was edited by: Chris Robertson

[former_member188975 · Accepted solution]

Hi Chris,

"I'm not bright enough this mornig to figure it out"..are you talking about your problem, or how to award points...you just need to click on the star next to the answer if you want to award points

[chris_robertson · Accepted solution]

I'm refering to points. I don't think it recognizes me anymore as the original poster of the message that's why I can't get to the award point buttons.

(If you click on my name by the original post it will list my recent posts as the two from yesterday, but not any today. If you click on my name next to today's post it will list todays post as my recent ones but not yesterdays. So that's why I'm guessing that it does not recognize me as the original. I was able to gives point yesterday. It probably has something to do with me getting my account set up and changing my initial password yesterday. Thanks for helping understand the exception aggregate on the key field!)