hi all,
I am new to MM, I am just trying test packages,everytime to you create a new package in , it creates whole lot tables, procedures and fuctions in the back end database is that normal...?
Second question, after ceating package how do you create scorecards and metrics..? do have to use framework manager or metrics designer..?
thanks heaps.
Hi,
Yes it's normal to have a new set of tables/procedures/functions etc for each metrics package. Typically you would store each in a separate database/schema.
After you create a package, you can either use Metric Studio to create your metric types/metrics etc, and/or you can use Metrics Designer, and/or you can populate text files with the relevant data and import, and/or you could write the relevant entries direct to the staging tables using an ETL tool and then transfer to the live tables.
Regards,
MF.
Thanks MF. Appreciate your help.