Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My diamension 1 to 4 have 30 items for user selection.
I have to duplicate my script 4 times. and when i change i need to change at 4 part. it there a sample approach ? ( Notice that the only different is 1 2 3 4.
Sample of my code as below :-
WhatIfDimension:
LOAD * INLINE [
Pls select 1st Dim,Column1
Desc,GL_DESC
Code,GL_CODE
company,company
];
WhatIfDimension:
LOAD * INLINE [
Pls select 2st Dim,Column2
Desc,GL_DESC
Code,GL_CODE
company,company
];
WhatIfDimension:
LOAD * INLINE [
Pls select 3st Dim,Column3
Desc,GL_DESC
Code,GL_CODE
company,company
];
WhatIfDimension:
LOAD * INLINE [
Pls select 4st Dim,Column4
Desc,GL_DESC
Code,GL_CODE
company,company
];
Hi Paul,
You may try script below to reduce repeat typing in load script:
For Each i in 1,2,3,4
WhatIfDimension$(i):
LOAD * INLINE [
Pls select $(i)st Dim,Column$(i)
Desc,GL_DESC
Code,GL_CODE
company,company
];
NEXT i;
By the way, you may thinking about Alternative State function also.
Regards,
Sokkorn
Hi Paul,
You may try script below to reduce repeat typing in load script:
For Each i in 1,2,3,4
WhatIfDimension$(i):
LOAD * INLINE [
Pls select $(i)st Dim,Column$(i)
Desc,GL_DESC
Code,GL_CODE
company,company
];
NEXT i;
By the way, you may thinking about Alternative State function also.
Regards,
Sokkorn
Concatenate those 4 tables , it will be definetely provide a solution...
Hi Sok
Thank you , it work.
The tiger is vey far away from you ?
Paul
Mr. Paul,
It around 0.5m away from me . You can find it in Changi Airport.
Regards,
Sokkorn