Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimensions and facts.
I don't want to execute the dim's part (create qvd for each dim) every interval, only every 3 intervals.
so my idea was to create a counter variable (if variable >3 run the dim's part).
any advise how to do that?
is it possible to pass variable from management console?
You could use something like this directly or outsourced as include-variable:
if $(vIntervalCounter) < 3 then
let vIntervalCounter = $(vIntervalCounter) + 1;
exit script;
else
let vIntervalCounter = 0;
end if
....
// Your Load-Statements
- Marcus
Thanks,
what is the best source to use for save the variable?
is it possible to pass variable from management console?
I'm not sure but I believe you couldn't pass such variables from the qmc - maybe the publisher had here more options. But you could generate such variable externally and store it in a textfile which could be load as include-variable and then use a logic similar to the above mentioned.
- Marcus