Search results for query: *

Hi all, I know, this is a newbie question, but am going brain dead... I have one cube that has a list of 20 items and a link going to another cube with a list of 15 business segments... I need to allocate a percent of each of the 20 items to each of the 15 business segments. Therefore, item 1...

Why does Analyst attempt to connect to Cognos every time we refresh an analyst view. This started to occur when we moved to Cognos 8. Several of us have this problem and it really slows down our process. A couple of our associates do not have this problem so it seems there may be something in...

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...

Hi, I was wondering if this can be done. I have two (or more) d-lists that are in separate libraries. (For example: Part Number D-list in Library A and Part Number D-list in Library B and Comprehensive Part Number D-list in Library C). Library A is for one country (Singapore) and Library...

Here's the scoop. I run the following macro, which looks at 5 cubes, but 4 of those, it looks at twice. I use two different date ranges depending on if I want Actuals only in my export, or Actuals & Forecast. I am using @AddLocalPreSelection to "hardcode" the date for both Actuals and Actual &...

Sorry for my lack of knowledge, but I do not see CognosScript Editor in Planning-Analyst. Is this for Planning-Analyst? If so, how do I open Script Editor? Thanks!

JDAEMS Can you give an example of what this would actually look like in a macro? I am not quite following, but maybe with an example, it will help and then I can tweak it. Thanks! JIM

Can this sort of thing be done in Planning-Analyst?

Hi all, In the macro I have been discussing in my other posts, I have been using "@AddLocalPreSelection" as my choice to choose a date that will apply across multiple cubes within the macro. However, for some reason, I am running into a problem with it NOT affecting a cube that is in a...

Hi all (again), I have a macro that does several exports into .csv files and was wondering if there was a way at the beginning of my macro to put everything into Read Only mode or right before each d-cube open/export pair of lines to put that open into a read only? I'd like to do so because...

Hi all, Is there a way to skip steps within a macro? For example, let's say my macro is set up to export data to 6 different .csv files. I run this on a weekly basis. However, let's say some weeks I don't want to update the 5th (for example) .csv file but I do want to update 1-4 and the 6th...

Hi - my first post, but hoping someone out there can help me as this would be a HUGE help to many of us where I work. Currently, I have a macro in which I lock or unlock several cubes within the macro. Basically, every cube in the model (around 20-25) are locked or unlocked. This happens at...