Help on Analyzing Type2 data - Relate Date range to date dimension

• Srivalli-490721

  Newbie

  Points: 1

  More actions

  October 1, 2010 at 6:16 am

  #142103

  Hi,

  Need help on ways to Analyze Type2 data across date dimension.

  I have a fact cum dimension table that has Type2 enabled.

  Columns in the table are - CompanyName, Measure, StartDate, EndDate => This Measure value is valid for this Company in this date range.

  For active records, EndDate is set to an Infinite date.

  Requirement is to get the data at daily grain.

  Users should see for each day , what is the measures value.

  Please let me know if theres a way to get this, other than exploding the data to daily grain ( Exploding data can't be considered since data volume is high )

  Thanks

  Santhi

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  October 6, 2010 at 5:28 am

  #1232386

  Santhi,

  Check this out...

  You have an aggreagte stored in UDM at Month level...how do you get the values at day level...

  not possible...:-)

  Raunak J