Loading Staging tables using PL-SQL/ETL tool

[snadgir30]

Hi All,

This being 1st attempt on metrics project , we have decided to avoid use of Metric Designer (MD) for loading staging tables.

  1.Now can any one tell me how one should go for staging table loading using PL-SQL or ETL tool?

  2.Do we need to populate all the tables staging tables mentioned or selected ones only?

  3.Any do's and dont's that should be followed.

  4.does any one has doc / cognos has provided that list detailed steps to be followed while ETL loading of staging tables.


help appreciated!

[shaud]

I asked this exact question last year and never got a response. So i'll tell you what i know.

i never found any documentation on using any etl's for loading the staging tables, but i used sql server's DTS tool for loading the staging tables. i don't know which version of cmm your using but i'm using cmm 2.2 (don't know how different Cmm 8 is)  and initially loaded all the objects (scorecards, metrics, diagrams ect;) into the "kpi_value_stage" table.  then you can ran option 4 to load and recaluclate. After loading the intitial objects, i now only load the updated metrics data via DTS on a monthly basis.

You'll have to manually run option 4 unless you create or call a batch file that will load the recalc the data. 

Hope this helps.

[snadgir30]

Thanks Shaud , for quick response!
sorry i forgot to mention of CMM i am working on ,its CMM 8.1
do you have any information on this?

[shaud]

not sure about CMM 8 because we're still on the previous release, but i would assume you could still apply the same or similar methods to get it to work.