Need a SQL script to extract a Level and its members selected in a worksheet filter.
Hi
I am looking for a SQL script to extract a Level name and its member values selected from a worksheet filter.
The worksheet has a level named Item and 96 members (item name) are selected.
The SQL script should show the worksheet name, level name and member values.
Please help. Thank you
Regards
Teik Thean