Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Hitman on 28 Feb 2008 05:45:38 AM

Title: Easy way to Zero out Anlayst & Contributor data
Post by: Hitman on 28 Feb 2008 05:45:38 AM
Hi
What is the easiest way to zero out Analyst cube data & contributor cube data?  :D
Title: Re: Easy way to Zero out Anlayst & Contributor data
Post by: jan.herout on 28 Feb 2008 06:30:05 AM
Analyst - macro with Command(zero). Contributor - in my opinion - Analyst Contributor link.
Title: Re: Easy way to Zero out Anlayst & Contributor data
Post by: ykud on 03 Mar 2008 05:23:37 AM
Analyst -- @Command(zero), surely.
Contributor -- Import with zero data option set. No files are required -- just select cubes. Another way -- Access Tables with No Data set, gtp, Delete AT, gtp.
Title: Re: Easy way to Zero out Anlayst & Contributor data
Post by: dermeister on 12 Aug 2008 03:45:16 PM
I agree with the Analyst method.

For contributor an Admin link with a "zero" dimension as the source seems to be the best if your data is purely numeric. Analyst-to-Contributor links are a pain to set up and run, but they are required to zero out d-list formatted fields.
Text only | Text with Images