crazy response from studio
I do query
it is supposed to give me top ten producers over several past months trending of premium
of course the ideal way is to do months on columns and producers on rows and premium in cells
but if I move measures.wp to where clause and do columns to months here is what I get:
dialog with a message (I hate) below
It is just as in an article online (((((!!!!!
SELECT {Periodstodate( [Txn Time].[Calendar Date].[Calendar Semester] ,[Txn Time].[Calendar Date].[Month Name].&[2022]&[November])} on rows,
TOPCOUNT( [Producer].[Producer Id].CHILDREN, 10, [Measures].[Wp]) ON pages,
[Measures].[Wp] on columns
FROM [Bridger Olap All]
WHERE (
[t Bd Transaction Types].[Hierarchy].[Type Cd].&[Week],
null:[Txn Time].[Hierarchy].[Full Date].&[2022-10-23T00:00:00]
)
SELECT {Periodstodate( [Txn Time].[Calendar Date].[Calendar Semester] ,[Txn Time].[Calendar Date].[Month Name].&[2022]&[November])} on columns,
TOPCOUNT( [Producer].[Producer Id].CHILDREN, 10, [Measures].[Wp]) ON rows
FROM [Bridger Olap All]
WHERE (
[t Bd Transaction Types].[Hierarchy].[Type Cd].&[Week],
null:[Txn Time].[Hierarchy].[Full Date].&[2022-10-23T00:00:00],
[Measures].[Wp]
)