TM1 Forum

Hi All, We have recently upgraded our 10.2.1 FP2 environment to IF6 and since then the export to excel function via contributor has generated different files names.. As an example, before the change the filename was File A.xlsx After IF6 the filename is now File+A.xlsx The file is still the same fil...

All, I haven't seen much talk about the Cognos BI 10.2 bin64\ssl directory. I understand that the Tm1 client needs to be upgraded on the Cognos BI server through the flash updates + manual tasks (uninstall, import, ikeyman command) but have any of you also replaced the default applixca cert that get...

Hi All, We currently have a dimension that has that 3 levels (level 2,1,0) i.e. Product Dimension: 2 - All Products 1 - Country {USA, Italy, England} 0 - Product {Item A, Item B ..} This dimension is to be used for the contributor workflow BUT we only want users to select a country, therefore ignori...

Thanks Paul & lotsofram for the help. I've tried both solutions and have decided to use the long function and concatenate each insert statement as shown below. Once the length reaches a max i.e. >500, it calls the ODBCOutput query and then sets the query back to ''; The query passes approx. 50 i...

Hi All, I have been using the ODBCOpen, ODBCOutput, ODBCClose commands in TI to push data from TM1 to Oracle via Insert statement in the DATA tab. This process has been OK for small data sets but struggles with larger data sets i.e. 700k records. To get around this, I have altered the TI to asciiout...

Hi All, We have multiple users that have Perspectives Access to 1 or more tm1 instances. We want to 'DENY' access to some based on AD groups via Capability Assignments (Access to Server Explorer). i.e. 'DENY' Forecast AD group in the Budget Instance 'DENY' Budget AD group in the Forecast Instance Th...

Workaround: We resolved this issue by wrapping the expression in a union and joining It to an element that will always be found in the dimension. As the active form view is zero supressed, it will rarely show rows that match the second expression. ="UNION({TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL(...

Hi Karthik1710, Yes, the query works perfectly when it can find an element in the dimension that satisfies the filter. Its when it doesn't satisfy the filter is when the query takes forever. When testing the MDX in the subset it works perfectly and when it cant find an element/s that satisfies the f...

HI Gtonkin,

Thanks for replying..

I've tried your recommendation and it still doesn't work..

I've also created another web sheet from scratch and it doesn't work.. Just to complicate the issue, I have replicated the multiple filters on another instance based on a different cube and it works....

HI All, Im finding some weird behaviour in active forms when using a TM1filter and it cant find any elements matching the wildcard search. example: Perspectives ="{TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Staff] )}, 0)}, '" & CONCATENATE("*",$M$29, "*"...

Hi,

Try configuring the same data source connection as the data source in BI on the TM1 server and BI server/s (Dispatchers) through ODBC as PC will try and use a local data source at run time.

Cheers,
SW

Sounds like a browser or user issue (I assume you're pressing submit from inside contributor and not at the workflow screen?).

Cheers,
SW

Hi All,

Firstly is anyone here on Tm1 version 10.2 and secondly have made the jump from FP1 to FP2?
I'm trying to clarify is we need to install FP2 on client machines or any servers where the TM1 client is installed as the Tm1 documentation isn't very clear.

Cheers,
SW

Hi All, Just a quick one to see if anyone has come across any issues with IE 11 when using TM1 10.2.1? I have tested IE 11 with contributor, tm1web and operations console with minimal issues. According to the IBM website TM1 10.2.1 is only supporting IE up to version 10 but support Cognos BI up to I...

Hi Jan - perfect advice, that is exactly what I did and everything works great - thanks!

Hi All, I'm not having much luck in finding a solution to expand all levels without pressing 'Click to expand' at every level in an active form. Ideally I would like to create a button that would expand the data set to the n level, TM1 already has the functionality to collapse to the highest consoli...

Might sound simple but that kind of view leads me to believe zero supression has been turned on and you arent showing all elements for all combinations. Perfecto! Turning off Zero Suppression on all rows did the trick! Thanks PlanningDev. Apparently this didnt happen with 9.5.2.. Interesting. Im st...

Hi All, We are using Cognos Tm1 10.2 and are experiencing some weird data formatting in Cube Viewer, Contributor & TM1WEB. When we open a cube in cube viewer and drag multiple dimensions as rows, duplicate columns are not being separated by the first dimension, refer to attached screenshot. (FYI...

Thanks for the reply DR. Things have progressed since my lost post but were still having issues with the Custom Query package connector option.. It seems no matter the Report I choose (from cognos BI) I am prompted to enter a data source signon. As explained before, It knows the data source and the ...

Bump, any outcome??