Query preparation failed. The query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies,)
from this query
SELECT
NON EMPTY
(TAIL
(
([Measures].[SUM],[BIBoardingDates].[Month Short Name].[Month Short Name])
,6)) ON 0
,{[DaysFromBoarding].[DFB].&[0]:[DaysFromBoarding].[DFB].&[60]} ON 1
FROM
(
SELECT
[DaysFromBoarding].[DFB].&[0] :
[DaysFromBoarding].[DFB].&[60] ON 0
FROM
[Strategy_Performance_Dashboard]
)
when I checked online the options is to remove the tuple on the column to something like this
SELECT
NON EMPTY
(TAIL
(
([Measures].[SUM])
,6)) ON 0
,{[DaysFromBoarding].[DFB].&[0]:[DaysFromBoarding].[DFB].&[60]}*{[BIBoardingDates].[Month Short Name].[Month Short Name]} ON 1
FROM
(
SELECT
[DaysFromBoarding].[DFB].&[0] :
[DaysFromBoarding].[DFB].&[60] ON 0
FROM
[Strategy_Performance_Dashboard]
)
---
But I am to produce a line graph from this set, and the first query will make it possible , because each column will be the measure unlike the second query that will return just two columns, please any advice.
cheers