Looking for MDX Query Help

• mtassin

  SSC-Insane

  Points: 23099

  More actions

  April 19, 2017 at 8:14 am

  #150574

  It's a pretty basic query

  It's a list of the screens of an application and the views a certain client has of the screen.

  SELECT
  {[Epic Screens].[Epic Screen].&[2502],[Epic Screens].[Epic Screen].&[2537]} ON COLUMNS,
  NON EMPTY CROSSJOIN ([Screen Loaded Calendar].[Months Periods].[All].Children,[Measures].[Screen Views]) ON ROWS
  FROM [Epic Performance]
  WHERE ([Clients].[Client ID].&[XXXXXX]&[27466])

  The missing 4 months of data are a sliding thing.  Current Month, Prior Month, Tertiary Month, and 3 months ago will always be null, as the calendar advances for instance, this month December (4 months ago) started returning data, and next month the 4 months ago will be January data and May, April, March and February will be missing data.

  

  If I run the same query but for only one screen, I get different results?

  SELECT
  {[Epic Screens].[Epic Screen].&[2502]} ON COLUMNS,
  NON EMPTY CROSSJOIN ([Screen Loaded Calendar].[Months Periods].[All].Children,[Measures].[Screen Views]) ON ROWS
  FROM [Epic Performance]
  WHERE ([Clients].[Client ID].&[XXXXXX]&[27466])
  
  Somehow something about the AS database design is causing this I think, but what would I look for that would only exclude this one screen, only for the most recent 4 months, and only when I bring it and another screen's data back?

  ---

  
  --Mark Tassin
  MCITP - SQL Server DBA
  Proud member of the Anti-RBAR alliance.
  For help with Performance click this link[/url]
  For tips on how to post your problems[/url]