Firstly ensure that you have setup your data sources on the machine that you are building the cubes (ODBC). If your data sources are setup and things are still not working you could try the script below.
This is what we use and it works fine.
---------------------------
OPENpy...
Craig,
The way to do this is to create two queries within Impromptu, then apply a filter...... when the filter is being applied select field_b in 'Dataset' this will allow you to locate your sub-query (IMR).
I hope this helps ???
Paul
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.