Fields in Aggregation Levels - Urgent.
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.