TM1 Forum

I want to disable commit button only in CAFE.However users should use TM1 Web to input data.

Hi Team,

We are using 10.2.2 FP1 and we recently got a request to disable the commit button in CAFE by user. Do we have this functionality to disable by user or to disable for all users.

Thanks & regards,
Deepak

Hi Team, I have a requirement where i need to limit the access to users for certain dimension elements . Destination. Company Business. All cubes are reporting cubes that are published to the cognos connection. Users need to access only dimension elements that they have access. Users need to View/in...

No i am just trying to VIEWZEROOUT(sToCube,sToView).

I have added only the relevant code for the issue. Please find the attached complete code for your reference.

Sorry for the confussions.

Below Prolog code for your reference. #Source and Target cubes and views sFromCube='st_XXX'; sFromView = 'sys.FSDM.' | sFromCube | '.INVPUBACTUALS'; sToCube='in_YY; sToView = 'sys.PUBSTG.' | sToCube | '.INVPUBPLG_ACT'; ############################################################################## #D...

Hi Team,

i have the error(Error: Prolog procedure line (377): Cell is not writeable) when i run the TI process using the data adim id, however the process is successfull if i use adnin id.

Not sure what exactly is causing the problem. Please help me ..

Thanks & regards,
Deepak

Hi Team,

I have 40-50 dimensions where each has 3-4 system generated Subsets , when i say system generated these are create by MDX statments in the processes.

Can you share the code to delete the subsets of all dimensions which are created with Prefix as 'SYS'.

Thanks
Deepak

Sorry for the confusion.. Process 1 : Delete the consolidated elements Process 2 : Update Hierarchy 1 Process 3 : Update Hierarchy 2 Process 4 : All leaf level elements. In process 1 we are deleting all the consolidated elements , as you have explained we are not breaking the parent child relationsh...

We have same code in bedrock too.. ### Go through dimension and delete all C elements ### nElementCount = DimSiz( pDimension ); nElementIndex = 1; While( nElementIndex <= nElementCount ); sElement = DimNm( pDimension, nElementIndex ); sElType = DType( pDimension, sElement ); If( sElType @= 'C' ); If...

You are right ... i have the first process to delete the consolidated elements as below. sDim='Account'; vDim_Cnt = DIMSIZ (sDim); WHILE (vDim_Cnt >=1 ); Element = DIMNM ( sDim, vDim_Cnt); IF ( DTYPE ( sDim,Element) @<> 'N'); DimensionElementDelete(sDim, Element); vDim_Cnt = vDim_Cnt -1; ELSE; vDim_...

Hi Team, We update dimensions with datasource option... ODBC link which connects to DB. Issue: Every time i update my dimension the default subset gets deleted which is creating problem to open the report in Cognos BI.(Query studio reports). Process Sequence : Dimension Name : Account. Process 1 : D...

I have the same issue can you please suggest wht you exactly did in feeders

Can any one share their experience on upgrade process from TM19.5.2 to TM1 10.1 version. If you can list what are specific check point we should aware of.... If you can explain your experience if you have faced any problems with Perspectives specifically ..... Note: We have Architect appliaction and...

Hi ..TM1 Gurus i need the best practices for TM1 with cognos 10 .Can any one share..asap...