Need to show all dimension values

• neeta.chander

  SSC Enthusiast

  Points: 155

  More actions

  July 8, 2011 at 1:23 am

  #145841

  Hi All,

  I need to show all dimension values in cube report even if those are not present in fact table. Is there some kind of left outer join relationship I can set for my dimension and fact which gives me all records of dimension table and corresponding of fact.

  Thanks in advance.

  Best Regards

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 8, 2011 at 2:07 am

  #1350189

  is this for a SSRS report?

  what I do in this situation is create a 'dummy' calculated measure in the data source and have it '= 1', as this measure will

  interesect all the dimension members when the query is run it shows all the dimenion members including that are not present in the fact table.

  Then use this data set for the report but dont show the calculated measure that you created.

  This method will also work without using SSRS, you just need to manually make the change to the mdx.

  there may be other ways but find this way works well.

• neeta.chander

  SSC Enthusiast

  Points: 155

  More actions

  July 8, 2011 at 2:26 am

  #1350194

  Thanks Steve...I'll try this approach...