Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Hiding members from a dimension that aren't used in a measure group Expand / Collapse
Posted Thursday, May 16, 2013 9:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:23 AM
Points: 2, Visits: 38
SSAS 2012


I suspect this is a seriously rookie question but I've not managed to find an answer on it so hoping someone can help.

I have an olap dimension, Order Date, which is based on a role-play view, dim_order_date_vw, based on a table, dim_date, holding 50 years of dates from 01/01/1970. I have an Orders cube, which is based on a fact table, fact_orders, with 10 years of transactions in it starting 01/01/2000. When browsing the cube in Excel and filtering by order_date, the dimension filter presents me with all dates from 1970. Is there a way of restricting this to just those that have corresponding orders?

One approach would be to tackle this in the warehouse by basing the view, dim_order_date_vw, on a join between dim_date and fact_orders. This has various downsides and I'm hoping there's a simple way of achieving this in SSAS?

Thanks in advance,
Post #1453624
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse