TM1 Forum

Does it matter.. The problem seems to be in logic, not in counter initialization and in loop. If i use code: FunctionDimNm = 'Function'; nDimCount = DIMSIZ(vFunctionDimNm); nElementCounter = 1 ; WHILE ( nElementCounter < nDimCount + 1); vElementNm = DIMNM(vFunctionDimNm, nElementCounter ); vValue = ...

Hello ALL, I am trying to clean cube data based on a dimension hierarchy for a specific roll up. Created one TI with coded embedded as : vFunctionDimNm = 'Function'; nDimCount = DIMSIZ(vFunctionDimNm); nElementCounter = 1 ; WHILE ( nElementCounter < nDimCount + 1); vElementNm = DIMNM(vFunctionDimNm,...

Hello All, Need a quick help. I have below statement in data tab but whenever i run the TI Process i get an error of SQL invalidity. sql= 'UPDATE MON_SAL SET UPI = get_decryption(UPI) WHERE UPI IS NOT NULL AND month =''APR'' and year = 2015'; ODBCoutput(strOrcDB, EXPAND(sql)); Please let me know wha...

Thanks Nick. But any setting done in tm1web_config file is universal. what if we have different applications (TM1 servers) and a different set of users for each applications. I want users tagged with one TM1 server must be routed to that specific server only. I am trying to have link like below: htt...

Hello ALL,

I am trying to create a URL which let user to go directly to a specific TM1 server (not a specific web-sheet or a cube view), so that they need not to select TM1 server from TM1 web link.

Any suggestion will be appreciated. Please note, i am using TM1 10.2.1 version.

Thanks,
Manoj

Hello ALL,

is there any way i can have a websheet open/downloaded directly in PDF format(functionality export to PDF) using a URL of web-sheet? I am trying to add a link (Web-sheet URL) to open up in PDF format.

Any guidance will be appreciated.

Thanks,
M

Hello ALL, I am facing a weird issue. I have implemented integrated security with Cognos BI in TM1 10.2.2. I am able to login through TM1 web, but not through Architect/Perspective. In Architect/Perspective, i am getting an error as " Error with CAM passport", not sure why. All ServerCAMUR...

Facing the same issue with TM1 10.2.1. installation.

Please let me know steps if someone is resolved the issue.

Thanks,

Thats not an issue, we can use either of them (as string or as serial number). Here is what we are currently on: to get difference, we tried (DAYNO(Date1) - DAYNO(date2))/30, but it does not fit into to get exact result as EXCEL DATEDIF() function gives. Actually we want to implement DATEDIF functio...

Hello All,

Is there any way to calculate months between two dates using Rules?

Please help.

Thanks,
Manoj

So far..so Good.. we acheived what customer was looking for..

But coding part is horrible, combining .NET code with TM1 API... Hope IBM will have some good documentation on usage of API in next release..

Thanks,

Agree with you mac...

As you are developing VB .NET and TM1 API, can i ask a question, how we can create a dynamic view using TM1 API in .NET. Any technical help would be highly appreciated.

Thanks,
Manoj

Thank for all suggestions. We don want to go heavily on .NET path, but for few interface design, we want to use API where users are stick to their requirement. and those interface are not that much complicated. Just to accept few data points using form and pass them to TM1 cube using TI. Just Read/W...

Sorry to say, but our users are quite picky ones. They want what they ask. Few of them are: 1. Calendar in cell as date input. 2. Use of Tab button to move from one form object to another. 3. Mouse over functionality on cell... 4. Reset option on action button... 5. Cacheing issue while using URL in...

Hello Gurus, To design TM1 interface, we are resorting on using .NET API of TM1 10.1. We are new in this territory and want to explore more on it. Business wants a great look and feel for one of our TM1 application so we want to create .NET page for interface, and that is quite possible using .NET p...

It is an excel drop down list. I think this is the reason for issue as excel retains the value between two records.

Please confirm.

Hello ALL, I am facing a weird issue, if you all gurus can help me in getting rid of that. In our application we have developed a screens flow in TM1 web using HTML pages and web-sheet pages. Now what we did, in a HTML page, a link redirects a user to a web-sheet where we have list as data pull from...

Thanks a lot for reply. Actually we put together a form design in web-sheet where we can't put input cell next to each other. so just wanted to know if anyhow we can implement Tab wise movement in that form. On 2nd point, we have created that form using web-sheet. I know we have Browser cancel optio...

Hello Experts, Need your help in figuring out how to implement these two options in web-sheets: 1. We designed a web-form using web-sheet in TM1 with cell for data inputs. as it is built on excel, so movement is cell wise. Is there any way i can make movement Tab wise from one data input cell to ano...

Hello ALL, I am trying to embed a VBA script in active forms which works fine in active form, but when i publish it on TM1 web, it does not work. Let me explain in detail, We have created an active form and there we have included a check box for each records displayed in worksheet so that if user ch...