topic Re: QS do it support Daimension Dynamic ? in App Development

QS do it support Daimension Dynamic ?

paulyeo11 — Tue, 07 Jul 2015 20:46:14 GMT

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 ?

Re: QS do it support Daimension Dynamic ?

dionverbeke — Wed, 08 Jul 2015 21:12:30 GMT

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

Re: QS do it support Daimension Dynamic ?

paulyeo11 — Thu, 09 Jul 2015 07:19:32 GMT

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;