Results 1 to 6 of 6

Thread: Mastering Enterprise BI: Time Intelligence Pt. III?

  1. #1
    Join Date
    Apr 2005
    Location
    CA
    Posts
    25

    Mastering Enterprise BI: Time Intelligence Pt. III?

    Mr Pearson,
    I've enjoyed your AS and MDX very much over the past two years.
    I'm using the "Business Intelligence Wizard" and have scripts but don't know the next steps. I suppose you would have covered that in "Mastering Enterprise BI: Time Intelligence Pt. III"
    Did you ever get to that?
    I'm having a hard time understanding the syntax.
    For example:
    /*
    Begin Time Intelligence script for the [TimeYMD].[TimeYMD] hierarchy.
    */

    Create Member
    CurrentCube.[TimeYMD].[TimeYMD TimeYMD Calculations].[Day Over Day Growth]
    As "NA" ;


    Scope(
    {
    [Measures].[Sales]
    }
    ) ;

    // Day Over Day Growth
    (
    [TimeYMD].[TimeYMD TimeYMD Calculations].[Day Over Day Growth],
    [TimeYMD].[Day attribute 7].[Day attribute 7].Members ( 1 ) : Null,
    [TimeYMD].[time_id 2].Members
    ) =

    ( [TimeYMD].[TimeYMD TimeYMD Calculations].DefaultMember ) -
    ( [TimeYMD].[TimeYMD TimeYMD Calculations].DefaultMember,
    ParallelPeriod(
    [TimeYMD].[TimeYMD].[Day],
    1,
    [TimeYMD].[TimeYMD].CurrentMember
    )
    ) ;

    (
    [TimeYMD].[TimeYMD TimeYMD Calculations].[Day Over Day Growth],
    [TimeYMD].[Day attribute 7].[Day attribute 7].Members ( 0 ),
    [TimeYMD].[time_id 2].Members
    ) = Null ;


    End Scope ;

    /*
    End Time Intelligence script for the [TimeYMD].[TimeYMD] hierarchy.
    */

    I would like to read and understand how to deconstruct what this is doing. Scope and "= NULL;" are new to me.
    1) does the formula begin after the "NA"? But it does not show in "Form View" for [Day Over Day Growth], why?
    2) [Day Over Day Growth]'s parent member (time) does not allow [Day Over Day Growth] to show in calculated members section of the cube browser. Am I looking in the wrong place?

    Stuff like that.
    Seems like a powerful wizard but I need a good article or two to get it.

    Thank you very much,
    Richard

  2. #2
    Join Date
    Apr 2005
    Location
    CA
    Posts
    25
    hi,
    ok I got to a point where I needed to be to continue. Please ignore my questions. The new calculated measure is part of the time dimension.
    I am curious about Mastering Enterprise BI: Time Intelligence Pt. III though.
    Richard

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Part III Yet to Come ...

    Thanks for the feedback. I don't recall, at present, what came of the Part III article. I will investigate, and look into getting it out there at some point - I have a significant backlog of pending titles, but will be happy to revisit this ...

    Thanks for your comments!

    Bill

  4. #4
    Join Date
    Oct 2009
    Posts
    1
    I am more interested in converting the Relative Time article into Analysis Services 2008. Thanks for your help.

  5. #5
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    No Part III in the Near Term ...

    Wish I had more time to write ... I'll try to get to Part III eventually.

    Bill

  6. #6
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    "Scope" and Other Concepts ...

    These concepts, btw, can be accessed in Spofford's MDX Solutions, Second Edition (my favorite) and several others.

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •