Need Help!!! SSAS Cube Structure

i designing cube , came across few challenges, can help?

challenge # 1: under cube structure windows have sort measure items way when process cube , browse in browsers folders , measure items under folders sorted alphabatically. need them show have sorted them under cube structure tab. how can that?

challenge # 2: have created time calculations ytd, mtd, qtd... etc. when try browse them in browser, works fine when try import data in power pivot takes extremely long time.

challenge # 3: initializing time calculation members null when browse them empty not appear. works when put time calculation member on row when try put on column, throws error until enable empty rows.

challenge # 4: have description field in fact table, creating dimension fact table , using description in dimension, when process cube, complains found duplicate attribute , doesn't work until change key want group data on description , not on key. how fix that?

thank you

 

---

aneel ismaily

challenge # 1: under cube structure windows have sort measure items way when process cube , browse in browsers folders , measure items under folders sorted alphabatically. need them show have sorted them under cube structure tab. how can that?

you can't this, clients tools choose sort measures alphabetically. there no specific sort property measures can use enforce particular order particularly when consider calculated measures need positioned too. best group related measures using display folders.

challenge # 2: have created time calculations ytd, mtd, qtd... etc. when try browse them in browser, works fine when try import data in power pivot takes extremely long time.

mtd, ytd, qtd etc not additive measures, better bring raw measures powerpivot , re-calculate "to-date" measures dax.

challenge # 3: initializing time calculation members null when browse them empty not appear. works when put time calculation member on row when try put on column, throws error until enable empty rows.

you have post error message getting , possibly examples of calcuation , query. particular axis calculation appears on should not affect how calculated.

challenge # 4: have description field in fact table, creating dimension fact table , using description in dimension, when process cube, complains found duplicate attribute , doesn't work until change key want group data on description , not on key. how fix that?

this should work. not able use description key if has duplicate values, have non-key attribute attribute relationship looked like: key -> description

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

SQL Server  >  SQL Server Analysis Services