TM1 Forum

Hi All, I'm trying to use the SwapAliasWithPrincipalName in the }Clients dimension to replace the users with a new namespace USER ID that we will be using. So to do this, I followed the below steps With Intergrated login mode as 1, 1) Created the new Alias and populated with the new names for all us...

Hi Again, With continuation to the OpenID Azure setup,the user accounts in our organization is enabled for Multi Factor Authentication , meaning that we first login with Password or get a Pass code notification in mobile authentication app & then Approve it with Fingerprint or PIN to validate th...

Elessar wrote: ↑Wed Jun 17, 2020 8:31 am It depends on your security requirements. Technically, you can configure gateway on any server. Usually it is on the same server with Cognos Analytics

Hi Elssar,

Set it up in the same server with Cognos Analytics and works fine. Thank you

Regards,
Chuks

Hello, You can use IIS reverse proxy / URL Rewrite to accomplish this. To do this, please refer to IIS documentation. The rule will be something like "http://server:9510/tm1web{R:1}" Hi Elessar, Thank you for the reply. Should the reverse proxy be setup in the public domain or can we have...

Hi All, We have TM1 Application configured with Cognos Analytics authentication. We have been using AD as namespace so far, but changing it AzureAD through Open ID connect. Our network flow goes like this Login Page --> CA with AZURE AD namespace Authentication Page --> FQDN:tm1web (9510 Port) This ...

Hi All, To understand StatsbyRule cube, i created a simple cube with 2 dimensions as shown below Cube name sample: sample.PNG The cube has a simple rule, sample2.PNG For the first time, when I turn on the Performance monitor and recalculate the view from Screen shot1, to capture the results in Stats...

ODI wrote: ↑Tue Oct 23, 2018 2:38 pm We had to recreate the cube to solve this issue

Yes,every time I recreated the cube after server restart and it worked again but stops when there is a next restart.

PavoGa wrote: ↑Mon Oct 22, 2018 12:34 pm Are you using any of the system control dimensions (}Cubes, }Dimensions, }Clients, etc.)?

In the Picklist rule? No we dont have any of the control dimensions.

Hi All, I have a cube with picklist activated, and whenever there is a server restart the picklist stop working. In the Logs there would be a warning, saying that Invalid picklist detected for cube, but no further details. The rules in the picklist is mostly Static with predefined choices to select ...

It worked! Thanks for your reply

Hi All, I'm trying to use this }Stats by Rule cube, but i don't see any information populated even after I compile the rule/ re save it again. I followed this documentation link https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_op.2.0.0.doc/c_statsbyrule_control_c...

Hi, Thanks for the reply! We currently have around 100 users in the system with already belonging to specific group. But their access to this dimension ( Project as given in example) varies user to user and is hard to define groups and hierarchies for that. is there anyother way to fix this? Thanks,

Hi All, Im wondering if there is a way to display the value of Consolidated elements to be based on the access a specific user has in Tm1 web, Example; Capture.JPG The user has access only to first 4 projects of Grp_A (A1 to A4) , so the view is as in the screen shot below, Capture2.JPG Now can we d...

Hi All I was trying to create a hierarchy based on the attributes using the CreateHierarchyByAttribute function in Ti process. Somehow when i run the process it says "CreateHierarchyByAttribute" function failed. I have used the syntax as given in documentation, Capture.JPG P.S the paramete...

I have tried in vain to achieve this and without any success! So would be very interested if anyone has a solution. I have therefore done either of the following when faced with this issue (which I suspect has already crossed your mind!): 1) Created an attribute that mirrors the string element, in ...

Hi All, I want to do a filter on an active form with 2 TM1RPT row dimensions to find out the list of combinations that match a string value in the cube. Cube name : test Dimensions: Dim1, Dim2, Dim3, Dim4,Dim5, Dim6, Dim7 and Test Measures. Example data in Cube: Dim1 Dim2 Type Name1 D1 Active Name2 ...

Not sure why you say since its an active form I cannot keep an excel sum to do the sum of selected items. I have done this on occasions by using MDX on the TM1RPTROW to return the required rows and then using excel sum to sum the entire relevant column, so something like =SUM($G:$G) on the active f...

Hi All, I'm trying to create a report for end user by using a filter on cube value which is entered by the user. For Eg: Cube A: Product -(p1,p2,p3) Line - (L1,L2,L3..) Measures -(Amount,Type) Data for P1: Line Type Amount L1 CategoryA 5000 L2 CategoryA 5000 L3 CategoryC 100 All Lines 10100 Expected...

Hi All, I have used the consolidated Avg function in a rule to get the average on Percentages. Below is the sample rule: Rule: SKIPCHECK; ['No Week','Sample %1'] = ConsolidatedAvg(1,'Cube Name', !Dim1, !Dim2,!Dim3,... ,'All Weeks','Sample %1'); ['No Week','Sample %1 Oversteer'] = ConsolidatedAvg(1,'...

Hi All, I have a P&L report which has all different accounting group costs displayed in USD. This report however takes more than a min to refresh while the same report using the local currency takes only few seconds ( less than 5 secs) to refresh. USD is calculated using a rule as given below, c...