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.

Regards,

BI_BPS_IP

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