Give me any example of semi and non additive measures?
- 1 Answers
- 1062 Views
- I also Faced
- E-Mail Answers
Answer / Rahul Gaur
"Semi-additive measures are measures that have a consistent value over a specific period (e.g., year), but can change between different periods (e.g., sales by quarter). Examples include headcount, inventory levels, or account balances. Non-additive measures are measures that do not obey the additive property and cannot be added across different periods or dimensions. For example, moving averages, cumulative totals, or percentiles."
| Is This Answer Correct ? | 0 Yes | 0 No |
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
what are the joins present in reportnet?which is most widely used?
1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?
What is Report item
in u r data u having duplicates how to fetch the latest data in our report?
----------------Diff b/w Dimensional modeling and Relational modeling?
What is the difference between a data mart and a data warehouse?
What is Metrics designer?
what is exact catalog size?
what are the filters in framework manager and report studio?
how you create security to cubes ?????
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
Teradata 
