Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
In QV I used to design report which allow dynamic change of Daimension.
When I try to binary load my QV QVW file to QS. I notice it does not support the above mention. I think it is Because QS does not all user go to system variable to declare columns variable.
Any work around ?
There is a work around:
Define an inline table in your script with your fields.
FIELD:
LOAD * INLINE [
FIELD
beer_name
brewery_id
];
Then create a field in a table and use the following as a dimension:
$(=FIELD)
Once you select a field it should display the values of that field you selected in the filter pane.
It is not the same, but a very close approximation.
Kind Regards,
Dion
There is a work around:
Define an inline table in your script with your fields.
FIELD:
LOAD * INLINE [
FIELD
beer_name
brewery_id
];
Then create a field in a table and use the following as a dimension:
$(=FIELD)
Once you select a field it should display the values of that field you selected in the filter pane.
It is not the same, but a very close approximation.
Kind Regards,
Dion
Hi Sir
Thank you for your advise.
My existing diamension is below , may i know it is possible to modify to your ?
For Each i in 101,102,103,104
WhatIfDimension$(i):
LOAD * INLINE [
Pls select $(i)st Dim,Column$(i)
CU_ID,cust_id
COY,company
BRA_C, BRAND_
BRA_F, bRAND
BRA_D,BRAND_SUB
];
NEXT i;