Sorting / Ordinal for dimension status attribute
3 posters
Page 1 of 1
Sorting / Ordinal for dimension status attribute
I have a dimension (vehicles) which carries a Status attribute. The various values that can exist in a status have a somewhat nature flow to their order (i.e. New, In Service, Sold). When displaying data grouped by this status value, I'd like to order my groupings by this natural flow. What is the best way to represent an ordinal for a given dimension value?
ryno1234- Posts : 33
Join date : 2015-01-07
Re: Sorting / Ordinal for dimension status attribute
You could add a report sequence attribute to the dimension.
Re: Sorting / Ordinal for dimension status attribute
Thanks, I had figured it might be as simple as adding new attribute, but I didn't know if a different method was more accepted.
Thank you again.
Thank you again.
ryno1234- Posts : 33
Join date : 2015-01-07
Re: Sorting / Ordinal for dimension status attribute
Would like to give a tip on creating a sequence and its data type. It is more flexible to use a decimal sequence data type then use a integer data type. For example if you already have a sequence number 1, 2, 3 and latter down the road business user wants to see "rebuilt" between "new" and "In Service" value, then giving a sequence value of 1.5 would prevent any re-sequencing if you used decimal data type.
seq#, value
1 , New
1.5 , Rebuilt
2, In Service
3, Sold
seq#, value
1 , New
1.5 , Rebuilt
2, In Service
3, Sold
zoom- Posts : 97
Join date : 2010-08-23
Location : Chicago
Similar topics
» Dimension Attribute or Fact Attribute
» Status attributes on main dimension or as separate dimension
» Status Dimension Brainstorm,
» Status - SCD Type 2 or dimension on the fact
» Separate dimension or dimension attribute
» Status attributes on main dimension or as separate dimension
» Status Dimension Brainstorm,
» Status - SCD Type 2 or dimension on the fact
» Separate dimension or dimension attribute
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum