7 Replies Latest reply: Jan 30, 2013 12:57 PM by 961807 RSS

    Price Analytics

    742636
      Hi All,

      We are implementing OBIA-Price Analytics 7.9.6.1, after installations we have done a intial run for Price analytics using 'CRM Pricing' subject area in the DAC repository.

      We are unable to see any data in the Pricing dashboards after the load run is successfully implemented.

      We have followed all setups steps before load run. Any help would be great.

      Thanks.
        • 1. Re: Price Analytics
          672283
          Can you tell me the source system whther it is Siebel or EBS that you are using...?

          If the source is EBS , did you configured the universal csv files?

          Redards
          Vishwanath
          • 2. Re: Price Analytics
            742636
            Source was eBS R12, we could solve the issue, the issue was with configuring Universal Source files which was not mentioned in the configuration document.

            But we have another issue loading out of box configuring OM and SCM OBIA ETL load, again the source is eBS R12, in the DAC the tasks are getting to 'Stopped' status from the queued status. ETL is not running, we have done the configuration as given int eh configuration document.

            Any help on this would be great help.

            Thanks,
            Satya.
            • 3. Re: Price Analytics
              672283
              Hello Satya,

              Can you please explain me how did you populated the csv files.

              Any help on this would be great help.

              Also if you have the SQL queries for populating the csv files then it would be helpful to me if you forward that files to vishwam_04@yahoo.com

              Thanks
              Vishwanath
              • 4. Re: Price Analytics
                742636
                We havent written sql queries yet for the Price analytics, would share it if I cross it.

                Thanks,
                Satya.
                • 5. Re: Price Analytics
                  672283
                  Can you explain , how did you configure universal adapter csv files.

                  Thanks
                  Vishwanath
                  • 6. Re: Price Analytics
                    user87727
                    Hello Satya,

                    We are using EBS 11.5.10, can you help me out in figuring out how to extract the price waterfall elements and the strategy columns from the EBS tables.

                    FILE_PRI_STRATEGY_DS --- this is the pricing strategy file.
                    FILE_PWF_ELEMENT --- This is the price waterfall elements file.

                    How to populate the above 2 files ?
                    Can you please help me out in populating the above files.

                    Thanks
                    • 7. Re: Price Analytics
                      961807
                      Hi

                      The understanding is that Pricing Analytics does not have standard ETL for EBS Source.
                      So what is the approach that has been taken in this case?
                      Is configuring universal csv files the solution for that?

                      Regards
                      Vinod