Forum Discussion
SASS Mutidimensional import Extremely slow
Power BI:
SELECT
{[Measures].[EOD Market Val - GBP]}ON 0,
SUBSET(
NONEMPTY(
CROSSJOIN(
CROSSJOIN([Date].[Date].[Date].ALLMEMBERS,[Fund].[Fund Code].[Fund Code].ALLMEMBERS),
[Instrument].[Instrument Parent Type].[Instrument Parent Type].ALLMEMBERS),
{[Measures].[EOD Market Val - GBP]}),0,4096)PROPERTIES MEMBER_CAPTION,MEMBER_UNIQUE_NAME ON 1
FROM
(
SELECT FILTER(
CROSSJOIN(
CROSSJOIN([Date].[Date].[Date].ALLMEMBERS,[Fund].[Fund Code].[Fund Code].ALLMEMBERS),
[Instrument].[Instrument Parent Type].[Instrument Parent Type].ALLMEMBERS),
(
(
(ISEMPTY(
[Date].[Date].CURRENTMEMBER.MEMBER_CAPTION)
OR
ISEMPTY("09-06-2016")
)AND
(ISEMPTY(
[Date].[Date].CURRENTMEMBER.MEMBER_CAPTION)
AND
ISEMPTY("09-06-2016")
)
)
OR
(
NOT(
(ISEMPTY([Date].[Date].CURRENTMEMBER.MEMBER_CAPTION)
OR
ISEMPTY("09-06-2016")
)
)
AND
(
[Date].[Date].CURRENTMEMBER.MEMBER_CAPTION = "09-06-2016")
)
)
)
ON 0
FROM
[CUBE]
)CELL PROPERTIES VALUE
SSMS:
SELECT
NON EMPTY { [Measures].[EOD Market Val - GBP] } ON COLUMNS,
NON EMPTY { ([Fund].[Fund Code].[Fund Code].ALLMEMBERS * [Instrument].[Instrument Parent Type].[Instrument Parent Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM
(
SELECT ( { [Date].[Date].&[20160609] } ) ON COLUMNS
FROM [CUBE]
)
WHERE
( [Date].[Date].&[20160609] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS