This discussion is archived
7 Replies Latest reply: Oct 4, 2011 9:43 AM by Sumant RSS

Snapshot and Scenarios

Sumant Newbie
Currently Being Moderated
Scenario snapshot:
Is there any way to execute snapshot query for scenario?

Thanks,
Sumant
  • 1. Re: Snapshot and Scenarios
    886918 Newbie
    Currently Being Moderated
    IOP supports following snapshot commands:

    snapshot data using query <queryname> from scenario <scenarioname>
    snapshot data using query <queryname> from scenario <scenarioname> replace
    snapshot data using query <queryname> from scenario <scenarioname> append
    snapshot data using query <queryname> replace
    snapshot data using query <queryname> append
  • 2. Re: Snapshot and Scenarios
    Sumant Newbie
    Currently Being Moderated
    Thanks ..:)

    However I don't see similar explanation in user guide...!!
    and when I tried executing the above statement it gives me error
    Admin> snapshot data using query "POR_Margin_CT" from scenario "h1"
    2011-09-22 14:22:58.226 NOTIFICATION executing: [snapshot data using query "POR_Margin_TT" from scenario "h1"]
    2011-09-22 14:22:58.241 ERROR Syntax error at line 1 column 43
    2011-09-22 14:22:58.241 ERROR snapshot data using query "POR_Margin_CT" from scenario "h1"
    2011-09-22 14:22:58.241 ERROR              
                                                    ^
    Edited by: Sumant on Sep 22, 2011 11:54 PM
  • 3. Re: Snapshot and Scenarios
    Sumant Newbie
    Currently Being Moderated
    Trying again...
  • 4. Re: Snapshot and Scenarios
    858140 Newbie
    Currently Being Moderated
    I am using below and it is working.

    snapshot data using query "Std_Cost_For_NextQtr" replace;

    Thanks
    Hari Devarapalli

    Edited by: Hari Devarapalli on Sep 22, 2011 7:03 PM
  • 5. Re: Snapshot and Scenarios
    858140 Newbie
    Currently Being Moderated
    Sorry I din't try aganist a scenario.Ignore my reply.
  • 6. Re: Snapshot and Scenarios
    886918 Newbie
    Currently Being Moderated
    The scenario snapshot will be available in future releases.
  • 7. Re: Snapshot and Scenarios
    Sumant Newbie
    Currently Being Moderated
    As a temporary solution....Matt suggested an idea.... Thanks Matt!!

    Find sandbox name for scenario (I have only one scenario)
    select a.name, a.sbox_id, b.name from is_responses a, is_sandboxes b where a.sbox_id = b.id;
    
    NAME                               SBOX_ID                NAME                                                                                                 
    -------------------------------- ---------------------- ---------------------------------------
    test                                      50                     sandbox-50                                                                                           
    Then snapshot data as below
    Admin> set sandbox "sandbox-50"
    2011-10-03 20:29:43.972 NOTIFICATION executing: [set sandbox "sandbox-50"]
    Admin> snapshot data using query "POR_Margin_CT"
    2011-10-03 20:29:48.496 NOTIFICATION executing: [snapshot data using query "POR_
    Margin_CT"]
    You should see the changes done in scenario also getting recorded.

    Thanks,
    Sumant

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points