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

Contributor: Making Cells Read-Only Depending on Time Dimension

Started by kazanec, 04 Sep 2007 11:24:27 AM

Previous topic - Next topic

kazanec

Hi,

I'm trying to make all cells for previous week(s) read-only in my Contributor model. Currently, I'm using Access Tables and each week am manually changing the access table to include the previous week. I intended on automating this process. Before I begin, I'd just like to make sure there isn't any easier way of doing this. My intentions are to create a small program that would generate a text file which in turn would be imported as an access table on a weekly basis. Is this the best option, or is there a function in Contributor Manager that would accomplish the same thing?

cbrandt

Hi,

No there is no such function in Contributor, but you can automate it by using Analyst and Contributor Macros.
1. Build an Access Table cube in Analyst (if existing, driven by some sort of period control cube).
2. Build a Macro that will export the cube as text
3. Call this Analyst Macro from a Contributor Macro, Import the Access Table and GTP
Done.

Cheers
Carsten

ykud

Just a small addition:
Use @Time BiF and automatically calculate weeks to close in an Analyst cube.

kazanec

Thanks! With your help, I was able to get this going in no time.