cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregate on 0CALMONTH

chris_robertson
Participant
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

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
Participant
0 Kudos

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

Former Member
0 Kudos

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

former_member188975
Active Contributor
0 Kudos

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
Participant
0 Kudos

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
Active Contributor
0 Kudos

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
Participant
0 Kudos

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!)