Adding a dimension

• suresh.muppidi

  Right there with Babe

  Points: 761

  More actions

  February 9, 2011 at 6:54 am

  #147002

  Hi,

  I have a dimension table like

  Dimension table name : ReportCodesDim

  Columns: Id, Name, Discription, ParentId

  Sample Data:

  1 Product Products Null

  2 Product1 Product1 1

  3 Product2 product2 1

  4 Region SalesRegions Null

  5 SouthIndia SouthIndia 4

  etc...

  Here i wish to create dimensions that has parent value null....

  Please suggest.

  Thanks,

  Suresh.

• cynthia.parker

  Ten Centuries

  Points: 1376

  More actions

  February 9, 2011 at 2:38 pm

  #1284845

  In your Data Source View you could create a named query, based on that table, with a "WHERE ParentID IS NULL" clause, then build your dimension off of that.

  - Cindy

  suresh.muppidi (2/9/2011)

  ---

  Hi,

  I have a dimension table like

  Dimension table name : ReportCodesDim

  Columns: Id, Name, Discription, ParentId

  Sample Data:

  1 Product Products Null

  2 Product1 Product1 1

  3 Product2 product2 1

  4 Region SalesRegions Null

  5 SouthIndia SouthIndia 4

  etc...

  Here i wish to create dimensions that has parent value null....

  Please suggest.

  Thanks,

  Suresh.