Forum Replies Created

Viewing 4 posts - 4,081 through 4,085 (of 4,085 total)

  • RE: SSAS Hierarchy Question

    It looks like your trying to use the same attribute as the name for each of your four hierarchy levels. You're going to need a separate attribute for the...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 24, 2009 at 6:33 pm

    #1030095

  • RE: MDX to calcluate weekday AVGs

    I came up with an even simpler solution. WITH

    MEMBER AvgPerDay AS

    Avg(

    [Due Date].[Dim Time].Children * [Due Date].[Day Number Of Week].CurrentMember

    , [Measures].[Fact Reseller...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 23, 2009 at 3:36 pm

    #1029323

  • RE: MDX to calcluate weekday AVGs

    When you specify [TimeDim].[Date].[Date], you're resetting the context for your measure to all dates. You need to filter your dates in your member expression by the current day of...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 23, 2009 at 3:33 pm

    #1029322

  • RE: How to implement "OR" condition between dimensions in the cube

    The user wants to be able to select all the orders that have :

    1. FirstCode1 or First Code 2 or FirstSecondaryCode2 or SecondSecondaryCode15 or FinalCode20

    Without really knowing the data, it...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 21, 2009 at 2:20 pm

    #1027914

Viewing 4 posts - 4,081 through 4,085 (of 4,085 total)