Today i have a requirement in my project. I need to generate a sales report for products which includes grouping at all levels of the product hierarchy. I need have a group footer which will show the corresponding measures summary for the particular level of grouping. As for as the numerical fields from the database are concerned i know the ReportNet column will calculate the sum at the corresponding levels if we give aggregation 'TOTAL' at Cube(Query) Level. I need to calculate the percentage based on 2 columns from Database. There is no problem in the detailed rows as for as the calculation is concerned. but when it comes to show the percentage at the sub group summary. I am not aware of using the aggregation = 'CALCULATED' property at Cube (Query) level. So for i am using the work around, I will calculate the totals for each sub group level in a data item and use it in another data item to calculate the percentage at the corresponding levels. This will definitely affect the performance of the report since the number of Data items and Calculations are more in this kind of approach.
So if we give Aggrgation proprty of a Data Item both at TMOD and Query level, we can use the particular calculations even in the Sub grouping level summaries.
Your feedbacks and Comments are welcome as it will provide a way to improve. May be my insight says my english is not much good. I am working on that, Please excuse.
So if we give Aggrgation proprty of a Data Item both at TMOD and Query level, we can use the particular calculations even in the Sub grouping level summaries.
Your feedbacks and Comments are welcome as it will provide a way to improve. May be my insight says my english is not much good. I am working on that, Please excuse.
No comments:
Post a Comment