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. 
 
 
 

Format SSAS Dates from '1900-01-01 00:00:00.000' to '01/01/1900'

 
 
Steps:
1. Add a Varchar Date to your Data Source View
go into your data source view
right click on your date tables header
create a new named calculation
 
 
 
make a new varchar date
 
 
 
 
 
2. In your date Dimenision, Add your new field as the NameColumn on your datetime field.
Find the date you want to change


View it's properties
 Change the namecolumn field , add your new field.