Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Am using "direct query" at script level for a single table.
The problem is if am using "if-else" in a listbox at GUI, its not working.
My requirement is like - I have one island table having single column as Period & values for this column is - CST/IST/PST.
& have three column in direct query as dimension i.e. TIME_CST, TIME_IST, TIME_PST.
Now what i need is in a single list box if am selecting CST, then the values should be come for TIME_CST ND if am selecting IST then in that same list box value should come for TIME_IST.
Need help on urgent basis.
Thanks in Advance.
I think calculated dimensions won't be possible using direct query.