If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

problems while migrating from DMR to Power cube

Started by kiran.timsina, 02 Jan 2014 04:34:37 PM

Previous topic - Next topic

kiran.timsina

I'm trying to migrate reports built on DMR package to Transformer power cube and I hit some problems.

1. First problem is in the folder structure of metrics.
A metric, lets says (Business Layer>Sales>Sales Retail) in DMR would be imported in power cube as (Measures>Sales Retail). I can make that structure to be (Measures>Sales>Sales Retail) but when I validate the reports (which were using DMR package) with power cube package I get an error saying that it doesn't identify the metrics, which is pretty obvious since the folder structure has changed. What is the best way to overcome this with very minimal changes in the reports?

2. The rollup type calculated is not supported in power cube, so how are calculated fields like Sales % change this year versus last year are calculated?
Edit: Figured out that calculated measure defined in FM has to be redefined in Transformer but it works.

cognostechie

Sales % change this year vs Last year is automatic in Transformer cubes. The Time dimension creates relative time which can be applied to every measure for every dimension. Expand the Time dimension and then expand YTD Grouped. You will see % change/Growth. So you don't need to create a measure for Sales % change in Transformer.

Cubes use a different MUN compared to DMR so you may have to open every data item and point it to the correct MUN of the cube.