locked
Default Member for Date RRS feed

  • Question

  •  All,,

    I need to know how to set the default member for my date dimension, So that every time i see my data it should display most current data.

    please tell me the code for this??????
    Tuesday, February 2, 2010 4:47 PM

Answers

  • See Mosha's blog on default members.

    http://www.mosha.com/msolap/articles/cubeinit.htm


    cheers,
    Andrew

    Andrew Sears, T4G Limited, http://www.performancepointing.com
    • Proposed as answer by Raymond-Lee Thursday, February 4, 2010 5:52 AM
    • Marked as answer by Raymond-Lee Wednesday, February 10, 2010 11:24 AM
    Tuesday, February 2, 2010 6:30 PM
  • I had similar request for a financila cube to show the current date(in my date dimension i had member property named "current date" which points to the current date) as the default member. i created the script that updates the cube.
    (Ex)

    Alter Cube
      CurrentCube
        Update Dimension [Datumi].[Datum Stanja],
          Default_Member = Filter([Datumi].[Datum Stanja].[Datum].Members,
                            [Datumi].[Datum Stanja].CurrentMember.Properties("Current Date")="1").Item(0).Item(0)

    • Proposed as answer by Raymond-Lee Thursday, February 4, 2010 5:52 AM
    • Marked as answer by Raymond-Lee Wednesday, February 10, 2010 11:24 AM
    Tuesday, February 2, 2010 8:03 PM

All replies

  • See Mosha's blog on default members.

    http://www.mosha.com/msolap/articles/cubeinit.htm


    cheers,
    Andrew

    Andrew Sears, T4G Limited, http://www.performancepointing.com
    • Proposed as answer by Raymond-Lee Thursday, February 4, 2010 5:52 AM
    • Marked as answer by Raymond-Lee Wednesday, February 10, 2010 11:24 AM
    Tuesday, February 2, 2010 6:30 PM
  • I had similar request for a financila cube to show the current date(in my date dimension i had member property named "current date" which points to the current date) as the default member. i created the script that updates the cube.
    (Ex)

    Alter Cube
      CurrentCube
        Update Dimension [Datumi].[Datum Stanja],
          Default_Member = Filter([Datumi].[Datum Stanja].[Datum].Members,
                            [Datumi].[Datum Stanja].CurrentMember.Properties("Current Date")="1").Item(0).Item(0)

    • Proposed as answer by Raymond-Lee Thursday, February 4, 2010 5:52 AM
    • Marked as answer by Raymond-Lee Wednesday, February 10, 2010 11:24 AM
    Tuesday, February 2, 2010 8:03 PM