topic Re: Alias Name for MDX Query in QlikView

Alias Name for MDX Query

Anonymous — Fri, 01 Feb 2013 05:52:16 GMT

Hi All,

How can i write Alias name in MDX query?

For eg., I have the query like this

SELECT

{

[Measures].[USD],

[Measures].[USD - Fct Budget],

[Measures].[USD - Fct Forecast],

[Measures].[FullYearActual],

[Measures].[FullYearBudget_vs_PriorFullYearActuals],

[Measures].[PriorYearActuals]

}

DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY

{[Dim Account Main3].[Account Key].Children}

ON ROWS

FROM [IB Test]

;

I want to give "Alias" name to all the measures here. Bcoz i am using the same measures in few more tables. Due to this i am getting synthetic key error in qlikview.

Thanks in advance.

Rgds,

Nandha

Re: Alias Name for MDX Query

er_mohit — Fri, 01 Feb 2013 05:54:24 GMT

hii

firstly load your all tables from sql then on abovewrite load and within this load write fields which you want to alias like below.

Load

[POST_GJAHR] ,

[BELNR_CN] ,

[BELNR_CN_CANC] ,

BUDAT_CN,

[VBELN],

BUDAT,

BELNR,

POST_ACC_AMOUNT as Debit_Credit_Amount,

KUNAG as KUNNR,

KUNNR as NewKUNNR,

BLART

;

SQL Select VBELN BELNR_CN POST_GJAHR BELNR_CN_CANC BUDAT_CN BUDAT BELNR POST_ACC_AMOUNT KUNAG BLART KUNNR from ZREBATE

;

hope it helps

Re: Alias Name for MDX Query

Fri, 29 Mar 2013 17:22:12 GMT

Hi,

Try to store everything in a qvd and the load again in this way:

Load

" [Measures].[USD]" as name1,

"[Measures].[USD - Fct Budget]" as name2,

"[Measures].[USD - Fct Forecast]" as name3,

"[Measures].[FullYearActual]" as name4

...and so on...

Let me know!