Re: Required urgently : How to get Last Visit to the customer

From: Deepak Puri (deepak_puri_at_progressive.com)
Date: 08/29/04 

Date: Sat, 28 Aug 2004 20:24:21 -0700

How is timeid exposed in the cube - is it a key or member property of a
Time dimension? Max() returns the highest value of the second argument
(numeric expression) over the first argument(set). So, in this case, how
does the expression: [Time Version].&[1] return a timeid value?

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Attribute relatioships not working?
    ... Microsoft SQL Server 2005 - ... My time dimension has both the fiscal and calendar ... browse the cube via the calendar hierarchy everything is OK. ... the meta data pane is not refreshed. ...
    (microsoft.public.sqlserver.olap)
  • Re: Customize the joins between my Fact table and Dimensions?
    ... I have created a shared time dimension that goes down to the day ... In my Cube Editor, I want to join my fact table to my shared time ... Key in the Time dimension table, which links to a foreign key in the ... I'm currently using my live OLTP database as the source. ...
    (microsoft.public.sqlserver.olap)
  • Time dimension - YTD Error when used in cube
    ... When it's used as a dimension in a cube, ... Unable to display cell properties ... When the calculated member was created, the syntax was fine and no error ... for the column that the Time dimension 'links' to. ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculated Member Properties?
    ... SSABI time dimension. ... >> Then create a member property for your Year level called Current Year, ... >> filters all of the records based on that member property. ...
    (microsoft.public.sqlserver.olap)
  • Re: Last month in Time dimension (named sets?)
    ... Most solutions I see here are talking about using a measure in the MDX ... Added LastMonth bit filed to time dimension table ... cube build in DTS ... > periodicity dimension dn named sets as I see it. ...
    (microsoft.public.sqlserver.olap)