1

I have my fact table that has data in weekly basis, so I am mapping with Week dimension to pull records in Piviot table. My ssas cube doesnt show all data that is in fact. Should I add any specific scope to show in cube. for Example, My fact has data for week 201839 as well as 201840 (Sep month weeks) but in cube I can see only for one week 201839 but not for 201840

  • Hi. Welcome to DBA SE. :) Can you query and join between them on the key that joins the fact to the dimension? Has the cube been processed since the data was updated? – Sir Swears-a-lot Apr 3 at 9:07
  • Check the queries in the DSV to populate the fact and dimension. Look for any where clauses that may exclude your data. – Sir Swears-a-lot Apr 3 at 9:12
  • Hi Thanks for you response. I verified by Joins with fact and dimension. It is fine. also verified the View created from Fact table. When I query in Management studio I get data for 201840. but not in ssas browser – Sandhya Balakrishnan Apr 15 at 8:26
  • Has the cube been fully processed since the data was added? – Sir Swears-a-lot Apr 15 at 9:18
  • Yeah, everytime I do full cube process. – Sandhya Balakrishnan Apr 26 at 6:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.