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?
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
Just a small addition:
Use @Time BiF and automatically calculate weeks to close in an Analyst cube.
Thanks! With your help, I was able to get this going in no time.