A union of curiosity and data science

Knowledgebase and brain dump of a database engineer


Order MDX query alphabetically - Member_Caption

SELECT
{ [Measures].[Sum of Orders], [Measures].[Sum of Cost], [Measures].[Sum of Demand Revenue], [Measures].[Average of CPM], [Measures].[Avg of AOV], [Measures].[Sum of Budget] }
ON COLUMNS,

{ 
Order(
[activity].[Funnel Position].[Funnel Position].ALLMEMBERS
, [activity].[Funnel Position].Member_caption, desc
)
} * { [activity].[Channel].[Channel].ALLMEMBERS }
ON ROWS

FROM [Model]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FONT_FLAGS, FORE_COLOR, BACK_COLOR

 

SQL Jobs for SSRS Subscriptions are made with a GUID as the name . Find the actual report.

The GUID within the Job is a nightmare, use the following query to find the guid for a SQL Server Reporting Server Report Subscription .
 
 
 

SELECT a.ScheduleID

, c.name

FROM ReportServer.dbo.ReportSchedule a

join ReportServer.dbo.Catalog c on c.ItemID = a.ReportID

where c.name = 'Report Name'

 

 
 
 
Of course there's always the option to open up these jobs copy the SQL and create your own scheduled task for running the Subscription.