7 Replies Latest reply: Oct 4, 2011 11:43 AM by Sumant RSS

    Snapshot and Scenarios

    Sumant
      Scenario snapshot:
      Is there any way to execute snapshot query for scenario?

      Thanks,
      Sumant
        • 1. Re: Snapshot and Scenarios
          886918
          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
            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
              Trying again...
              • 4. Re: Snapshot and Scenarios
                858140
                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
                  Sorry I din't try aganist a scenario.Ignore my reply.
                  • 6. Re: Snapshot and Scenarios
                    886918
                    The scenario snapshot will be available in future releases.
                    • 7. Re: Snapshot and Scenarios
                      Sumant
                      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