Is there any sample data available for Retail Merchandising System (RMS)?
if there is any sample data, please provide the Details regarding to it.
Appreciate the help in advance.
your understanding is correct,
i need demo data for RMS from where i can populate the data to RA (Retail Analytics) for Analytics purpose.
if u can provide demo data either for RMS or for RA it would be helpful.
Thanks in advance for ur help.
The demo data is inserted while you create the DB schema for the applications. While creating the DB schema itself it will ask you whether you want demo data or not !
So may may be your schema is created without the Demo Data.
The only thing you can do now is insert the data from backend (i.e into the database tables directly). Obviously its a big task.
But the good thing here is there will be sql scripts in the source file itself. You can run them so that the data is inserted into the database.
I really agree with your idea, but unfortunately we don't have option of Demo data insertion while creating schema for Retail Analytics.
and there are no scripts which i could found to populate the demo data for RA.
if you have any information on this pls help me providing the details of it
There is demo data for RMS, which can be inserted during install. You can also insert it later by manually running the demo data SQL*Plus scripts.
It might be in a different location in RMS13, but in RMS12, you can find the scripts which insert demo/seed data in the staging folder in /dbserverunix/data.
From there you can run rmsdemodata.sql.
However, there is only data for master data (options, udas, items, suppliers, etc), none for transactional data.
You would need to create your own.
One method would be to create your own transactional data in a text file run the migration scripts (in the staging folder under /dbserverunix/dataconversion
I do not know Retail Analytics so I am unsure how you would trigger this generated data to import into the Analytics module
Hope this helps
Edited by: Alan Lawlor on 17-Apr-2013 10:21