Has anybody tried to use the GetDataValue in a macro in Cognos. I am trying to run a list of reports that I have stored in a hotfile. I use the GetDataValue to get the prompts. At row 101 it quits working. Any ideas?
The GetDataValue method is a wonderful tool, especially if you combine it with an array. It allows you to retrieve data from Impromptu back into the macro and store the data into an array for loop processing. There is another set of methods, the SQLExec family, that can achieve the same results without the overhead of Impromptu. I use it when I want to 'slim down' the process, or when row count accuracy is vital.
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.