Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Fields in Aggregation Levels - Urgent.

Hi Gurus,

I created a basic cube and so as with same structure a Plan Cube. Now also I buit a Multiprovider on top of these 2 cubes.

Now in Planning Modeller, Iam creating Aggregate Levels, Filters.

Say for Ex, I need to report upon Customer by Customer Group Sales figures, and also Customer by Material Group / Material Sales Revenues.

I have say Customer Group, Customer, Profit Center Hierarchy, Material, Material Group, Company Code, Sales Organization fileds available in both Cubes.

I figured out from the req "Customer as my lowest Granularity",

Now Questions are,

1. What fields I need to put in Aggregation Level. When I ask this I mean, " Shall I suppose to keep only those fileds of lowest Granularity ( Here Customer) or else I can still include all fields(Cust Group, Profit center Hierarchy and other Fields also) above the lowest Granularity (Customer),

2. What happens if I includes all fields I have into Aggregate Level and I use in the Input Queries what ever fields I want to report upon. To be more clear on this say here cant I build my Input Query on Customer Group, though I have a choice to plan till Customer?

3. If we want different levels, say here for ex if we want to report on Customer Group I need to go for one AggregateLevel,

Customer - Different Aggregate Level.

Company Code - Different Aggregate Level?

I am confused in including the filelds inside an Aggregae Level. I really appreciate some ones help on this.

Thanks in advance and waiting eagerly for your quick helpful inputs. Points shall be assigned promptly.



Not what you were looking for? View more on this topic or Ask a question