crazy response from studio

greg lipman 81 Reputation points
2022-12-09T09:51:45.74+00:00

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]
)

268923-message.jpg

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,329 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.