Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jimicron2

    How do I allocate something?

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

    Excel Add-in connecting to Analyts to refresh views issue

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

    List of Exports to choose from within macro in Analyst

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

    Update a D-List in Analyst from two Ascii Files

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

    Is there a way to do this in Planning Analyst with date selection?

    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 &...
  6. jimicron2

    Is there a "skip" step or a way to "skip" in a macro?

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

    Is there a "skip" step or a way to "skip" in a macro?

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

    prompts with multiple options

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

    Function, "@AddLocalPreSelection," question

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

    Is there a way to put at the beginning of a macro to open all cubes as

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

    Is there a "skip" step or a way to "skip" in a macro?

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

    Select date range once to apply to entire macro?

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

Part and Inventory Search

Back
Top