Which two options would provide a better design for the following accounts and metrics?

Which two options would provide a better design for the following accounts and metrics?

A.
If there are a small number of accounts that require FTE and Expense dollars, split
Accounts and Metrics into 2 dimensions

Which two options would provide a better design for the following accounts and metrics?

A.
If there are a small number of accounts that require FTE and Expense dollars, split
Accounts and Metrics into 2 dimensions

B.
If there are a large number of accounts that require FTE and Expense dollars, split
Accounts and Metrics into 2 dimensions

C.
If reporting dictates FTE and dollars in the columns and accounts in the rows, split
Accounts and Metrics into 2 dimensions

D.
If block size is large, then keep Accounts and Metrics as one dimension with a dense
dimension

Explanation:
Use Application Design Best Practices, Minimize the number of dimensions, Avoid
Repetition in dimensions,
Avoid inter dimensional irrelevance
http://www.scribd.com/doc/40391863/10-Hardcore-Essbase-Tuning-Tips-You-Ve-NeverHeard-Before



Leave a Reply 0

Your email address will not be published. Required fields are marked *