TM1 Forum

Apologies for the delay. I am using 9.5.2 with Parallel Interaction ON. I also run viewcontruct and add dependecncy before the process run. But still, only these two cubes gets locked from read operation. The processes are run from TM1 chore. I am not sure if TM1 is effective in real-time environmen...

whilst a BI process is running That's a pretty broad statement. Just what exactly is this "BI Process" doing? Sounds like you need to look here instead of your rules, which IMO look reasonable. Sorry it's TI process;TI process is basically loading data from data warehouse, It also add new...

hi, One of our cube is getting locked whilst a BI process is running , not letting any user to refresh excel report and browse cube from perspective. The TM1 top shows status as IX:<cube name against the process name. I noticed that when I remove feeder statements but keep skipcheck only then it doe...

No worry I managed to fix it.

Thanks a lot - Qml. you saved my day:)

Think about it, you don't want to be feeding the previous year, but rather the opposite, the previous year should be feeding the following one. You need another attribute for that, let's call it NY for 'next year' and it needs to be the reverse of what PY does. Then you use PY in your rule (like no...

hi, I am facing a strange issue, the feeders are not being calculated unless i am hard-coding a dimension element name.Here's the detail: Rule: ['Actual PY']=N:DB('PSP',!PSP Provider,!Domain,'Actual',ATTRS('Time',!Time,'PY'),!PSP Accounts,!Measure PSP); --The rule is basically assigning value of ele...

Thanks Tom, I am now exploring excel macro functions which appears to be much easier than API. But there are some tasks which excel macro can not perform such as autheticating against cam security using single login screen.

hi, I am trying to get NAME attribute of the control dimension "}Groups" . In order to do that I first get that value stored in the object handler as below ' -- handler to ger dimesnion object grpDimesnion = TM1ObjectListHandleByNameGet(pPoolHandle, vServerhandle, TM1ServerDimensions(), TM...

Thanks a lot - Mike, this is working fine now.

Thanks a Lot Mike, I finally managed to correct it by creating NAME attruibute in }Clints and }group dimension and using same name which I am passing into the code. It seems that the username which is passed during login is not the same user name which TM1 refers in the function. This is working for...

hi, I am trying to check if a client is assigned to a CAM group or not. For this, I am using TM1ClientGroupIsAssigned function and checking the result by wrapping it with TM1ValBoolGet , but it returns 91 , meaning some parameter has not been passed correctly, I am able to login and run the ti proce...

Thanks a Lot Mike, this is working fine now.

this wasnt in the documentation

hi, I am not able to login to cam connection using TM1 api function TM1SystemServerConnect. ~It appears that this function only works for standalone TM1 security. We have cam authentication enabled with cognos 8 security. Does anyone know if there's any function for cam connection? kind regards Prad...

No worries - I have managed to figure this out- Anyway thanks alot lotsa

Thanks a lot - Lotsa.

Just one more doubt, any idea how the "Report Orgin" and "Levels" fields are being populated ?- it does not look like a excel combo box.

kind regards
Pradeep

hi, I am trying to understand a Active form which is using dynamic paremetrised MDX but not able to understand the implementaion. In the spreadsheet ( screen print below), the formula at the top left row looks like this =TM1RPTROW($E$8,"Planning Sample:plan_chart_of_accounts","",...

Thanks Tom and Ankur - I will try these.

Hi, Wonder if this can be achieved in TI. I have a requirement to load files where order and number of column changes everytime the new file arrives.I only need to load some columns from the file, these columns can be selected by column title. when I try to achieve this using formula TI process fail...