I want to know the best practice to check the status of the flag in a lookup cube for 1 and call another process.
I am aware of one option below:
flag1=cellgetN('LOOKUPCUBE','USA',Monthdim,'flag');
If(flag1=1);
executeprocess(procname);
endif;
please advice if there is any better option?
get flag status from cube
-
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: get flag status from cube
Hi,
I don't see any issue with this approach - are there specific problems you are trying to avoid by asking for an alternative?
I don't see any issue with this approach - are there specific problems you are trying to avoid by asking for an alternative?