This discussion is archived
7 Replies Latest reply: Jan 30, 2013 10:57 AM by 961807 RSS

Price Analytics

742636 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    We havent written sql queries yet for the Price analytics, would share it if I cross it.

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

    Thanks
    Vishwanath
  • 6. Re: Price Analytics
    user87727 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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