Start page in pcMobile/EPM Performance Canvas from today's date


1. In Canvas Planning create a new measure:

CREATE MEMBER [Sales].[ToDay]
AS
'[Time].[Time].[' + CStr( YEAR(NOW()) * 10000 + MONTH(NOW()) * 100 + DAY(NOW())) + ']' ,ASSOCIATED_MEASURE_GROUP='MeasureGroup';


2. In pcMobile create a slicer with the date:


a. Right click on the slicer and select initial selection

b. Do custom selection as:

SELECT {STRTOMEMBER([Measures].[ToDay])}

ON COLUMNS

FROM [Sales]