TM1 Forum

Thanks Lotsaram! After I added the cell security, it worked like a charm.

Hi All, I am having the same issue and hope it was resolved. Can someone please let me know what the issues could be? Admin users can see the rollup numbers and non admin group cannot. We have a contributor application and manage-rights security is on Projects dimension. This part works well. I have...

Thanks Emixan. So, is there's no way to hide the server?

Thanks,
Paul.

Hi,
I have a requirement to hide TM1 databases or Servers in Architect/Perspectives/PAW/PAX. Is there a way?
We want to allow only users that are in a particular group to open the databases. Thanks,
Paul.

Hi All, I have a TI (TI1) Process that calls another TI2 process in the Epilog. TI1 works fine when I run it from Architect. When I run this from contributor , TI1 fails with error "Could not initialize process". If I comment the TI2 process in the epilog, TI1 runs fine. Can someone please...

Thanks for all your advices. Yes, just the rule was enough.
The mistake I did was - not feeding the calculations properly within the Labor cube. Due to this, rollup was not working. Once I fixed it, was all OK.

Thanks again!
Paul.

Thanks Gtonkin and BurnStripe for the advices. Sorry I was away and could not get to this earlier. I have tried this approach, and the rule works, but the consolidation fails because of the feeder which runs out of memory. ['Productive Hours'] = N: If( ATTRS('Versions', !Versions, 'LiveVersion') @= ...

Thanks Declanr for the quick response. I tried to change the feeders to 'All projects' for one employee and I still got the same response. There are about 1600 projects. But employees are about 100 that work on that project. ['Standard Hours'] => DB('Labor','All Projects', '900040',!Months,'Forecast...

Hi All, I am having an issue with a feeder. I am trying to feed Standard hours into Labor cube and after I wrote a feeder like below, it just consumes all the memory and does not return until the server runs out of memory and I kill the service and restart. Feeder: ['Standard Hours'] => DB('Labor','...

Hi Wim,
Thanks for the advice and I will certainly use it. On further analysis, I found the feeder was from a different cube. I will create a new one rather than use the same thread.

Thanks,
Paul.

Hi All, I have a rule and having a hard time writng a feeder. Can someone please help? The rule works but on zero suppress, it disappears. Rule ['Cost']=N: If ( ATTRS('Versions', !Versions, 'LiveVersion') @= 'Y' & !Accounts @= DB('LaborGroupType', ATTRS('Projects', !Projects, 'PAG') , ATTRS('Emp...

Sorry I did not mention a point that Transaction Logging is turned on for the }ElementSecurity_cube. After I run the manage rights, I see in transaction log that security s applied. But I do not see what wiped off.

Thanks,
Paul.

Hi Gurus, Everyday after our nightly chores, I see that for a few elements, security is wiped off for all groups in }ElementSecurity_cube. There'snothing that indicates what wiped off in transaction log. I googled but there's nothing that points to my error. How do we debug? There's no porcess that ...

Thank you verymuch Declanr and Wim. }picklist cube was the reason.
Also how would I refresh the picklist?

Thanks a ton!

Hi Gurus, We are using PA - 2.0.9.5 version. I have changed a subset list elements - used as a picklist - in a cube and the new values do not showup in architect/Perspectives. Worse is, the old elements show in dropdown up even after I deleted the "subset:Dimension:SubsetName" from edit el...

Thanks everyone for the responses. Yes, I now understand why rates need not be fed. I will take these ideas. There was rate data feeding for over 10 years and it also consumed about 25GB memory.

Thanks again,
Paul.

Thanks for the reply steve. Sorry, one mistake in my earlier statement. There is rate populated already (other than rate, almost nothing else is populated) and the projection is for about 10 years. I removed the feeder and restarted which took like 50 secs to start the server. Is there any way I can...

Hi Gurus, I have a feeder for a rule to escalate rate to future months and the rule took about 20 min to save. The model has no data and I am guessing it must be something with the feeder. Can some tell me how I can debug the feeder? SKIPCHECK; ['Rate']=N: IF ( ATTRS('Version', !Version, 'Live') @= ...

Hi,
Can we do a tab break in PAW or PAX like we do page break on a grouped column in reporting?


Thanks,
Paul.

Thanks for all your replies - Tomok, Michel, Lotsaram. This helps me conclude my search.

Thanks,
Paul.