Post reply

Need to show all dimension values

  • 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

  • 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.

  • July 8, 2011 at 2:26 am

    #1350194

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply