Multiple Measures

building semantic layer
13

As long as this time difference is calculated between two columns in the same table, I don’t see what has to do with his problem ?
(with regards to incorrect results, not to performance 8) )
As long as you do something like sum(dateend-datestart) and not just dateend-datestart.

I do worry about the count(distinct). That could easily lead to false results.

Some general rules:

  1. create measures with aggregate functions in the select
  2. don’t create measures and dimensions from one universe table, use aliasses
  3. don’t create objects from a table, alias every table (so you would have something like TableA, DimensionAliasTableA, MeasureAliasTableA)
  4. read the designer faq

BTW: I still have no clue about the data in your tables, so I guess MarkP and I are still a bit clueless about the actual situation… :?

highandstoned :netherlands: (BOB member since 2005-08-01)