COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: StuartS on 29 Sep 2008 04:34:24 AM

Title: Best Practice
Post by: StuartS on 29 Sep 2008 04:34:24 AM
Hello

I two options for a process and I was wondering if one is 'best practice' compared to the other.  Perhaps they are as good as one another?

I have two models in contributor.  Each model has an 'assumptions' cube.  The data in the assumption cubes is use for two purposes.  Providing information to other cubes and providing feed to an access table generator. 

Model 2 contains all elist items that model 1 contains and 6 extra items.

Option 1.  Load the asumptions data into each model using copy load prepare.

Option 2.  Load data to model 1. Admin link to model 2, providing a smaller copy load prepare for the additional elist items.

What are peoples views? 

Regards

Stuart
Title: Re: Best Practice
Post by: adityashah27 on 29 Sep 2008 03:54:41 PM
i think i have misunderstood this, but basic thing is ,you can not load data in Assumption cube using "Import Data" (copy-load-prepare).
Title: Re: Best Practice
Post by: StuartS on 30 Sep 2008 03:11:15 AM
I have omitted a detail.  Terminology, apologies.  The assumptions cube I am dealing with has the elist as a dimension. 

If the elist was not present you would be correct. :)

Regards

Stuart
Title: Re: Best Practice
Post by: noraneko on 30 Sep 2008 08:47:48 AM
Option 3 â€" data loading from analyst to contributor.

I import data when I need to copy data in another business area.
Admin links â€" if I will use them in the future and often.
Analyst to Contributor links â€" for loading data *not often* (sorry my English)


Title: Re: Best Practice
Post by: adityashah27 on 30 Sep 2008 10:23:52 AM
got it. i will go with option 2, its just because i am more comfortable using admin link than import data.