Hi All,
I have created new dimension and modified the retail cube. I have processed the dimensions and cube. It is working fine on the SQL server management editor.
I am getting the error message when I tried to create a new dataset on the SSRS report for the below MDX query. But, this MDX query is working fine in the SQL server management editor. Can you please help me to solve this issue?
Error message:
Microsoft Visual Studio
The MDX query for the OLAP Data Source is not valid. The following error occurred : The ‘[TES_RETAILSEASONTABLE].[SEASONCODE].[SEASONCODE]’ object was not found.
Parameter name: uniqueName
OK
MDX query:
with member [SeasonCode Label] as ‘[TES_RETAILSEASONTABLE].[SEASONCODE].currentmember.member_caption’
member [SeasonCode Value] as ‘[TES_RETAILSEASONTABLE].[SEASONCODE].MEMBER_UNIQUE_NAME’
select non empty
{[SeasonCode Label], [SeasonCode Value]}
on columns,
Except (
[TES_RETAILSEASONTABLE].[SEASONCODE].members,
{[TES_RETAILSEASONTABLE].[SEASONCODE].&[Unknown], [TES_RETAILSEASONTABLE].[SEASONCODE].[All].UNKNOWNMEMBER,
[TES_RETAILSEASONTABLE].[SEASONCODE].[All]}
)
on rows
from [Retail cube]
Thanks,
Hari