I am creating a macro for a user in Analyst. The user runs 3 reports each month using three exports and three links. Depending on what link she chooses to update her zeroed out cube, will depend on what export she runs.
I have found a way to have the macro list the three links during the running of the macro. I am using the Variable Input capability which is the tab next to the Code tab. So, that obstacle is taken care of. Now, later in the macro, I need to do her second half, which is the export. I'd like to provide the same sort of list option like she had for the links, but can't be done as far as I know. Since the link option is variable and not static, I also have to have the export option variable.
Do you know if any logic can be built into the macro so that if she chooses link A, then run Export A… if she chooses link B, then run Export B, etc.?
Yes, could just create three macros for her (one for each report), however, she also would like to have a "pause/review" in the middle of the macro so that after she runs her link, she can review the d-cube to make sure it looks okay and if needed, make any edits, then have the macro continue. I have a request into Cognos on this capability b/c someone there told me in a round about way, this can be done. But if it can't, then I need to create 2 macros (part A and part B) for each export (three) so I'd end up with 6 macros. She doesn't run the reports at the same time b/c they hold different data that is provided at different times - that is the reason I just don't do them all in one macro (fyi).
I have found a way to have the macro list the three links during the running of the macro. I am using the Variable Input capability which is the tab next to the Code tab. So, that obstacle is taken care of. Now, later in the macro, I need to do her second half, which is the export. I'd like to provide the same sort of list option like she had for the links, but can't be done as far as I know. Since the link option is variable and not static, I also have to have the export option variable.
Do you know if any logic can be built into the macro so that if she chooses link A, then run Export A… if she chooses link B, then run Export B, etc.?
Yes, could just create three macros for her (one for each report), however, she also would like to have a "pause/review" in the middle of the macro so that after she runs her link, she can review the d-cube to make sure it looks okay and if needed, make any edits, then have the macro continue. I have a request into Cognos on this capability b/c someone there told me in a round about way, this can be done. But if it can't, then I need to create 2 macros (part A and part B) for each export (three) so I'd end up with 6 macros. She doesn't run the reports at the same time b/c they hold different data that is provided at different times - that is the reason I just don't do them all in one macro (fyi).