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,
Hi, Please I have this output in bids,(

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


September 7th, 2015 3:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics