TM1 Forum

Thanks for sharing this @SeanT it helped. Hi all, I have managed to solve this issue. Basically I was left with just one missing step, whereby I copied the files in tm1_installation_path -> bi_interop -> webcontent and paste them into ca_installation_path -> webcontent -> bi folder. Then modify the ...

Hi mate,

Just wondering if you have fixed this issue already, I am going through the same issue now with CX10.2, I have made sure I add users and tag them to respective groups in Cognos BI before adding and assigning a user to a group in TM1, still no luck.

Cheers,
Venu.

Excellent Guys! Thanks aton... ISERROR worked. :D :D :D :D This will solve the current issue, but I am still curious if I can do such an MDX filter in Dynamic Subset, so that I can reuse the same in multiple views, with current solution I have to create an active form for every situation. Thanks, VG.

Only that SEARCH function like I mentioned before, I am decoding (as u can see below) "N" as "N%" at leaf level as I have got few of the metrics supposed to show in percentages. =IF(TM1RPTELISCONSOLIDATED($C$28,$C28),IF(TM1RPTELLEV($C$28,$C28)<=3,TM1RPTELLEV($C$28,$C28),"D&q...

Hi Wim Gielis, Many thanks for your reply, yes your right, it works fine in Excel (Active Form) like you said, I have done that in following way. C12 = "{FILTER( {TM1DRILLDOWNMEMBER( { HIERARCHIZE( {TM1SUBSETALL( [Metrics_Sales] )} ) }, ALL, RECURSIVE )}, [Metrics_Sales].[" & C15 &...

Hi, Just to give a background we are using Cognos Express 10.2.2 and this question is relevant to MDX (Creating a dynamic subset using MDX Expression) Following is my requirement... I have a Dimension called "Vertical" which has got elements like HR, Sales, Finance etc... And another Dimen...

Hi,

Putting,

ODBCOpen ( 'DSN', 'User', 'Password' )

; in prolog in a process (which calls both Unwind & Dim Populate TI Processes) worked for me, incase if DB is down its not going further but gives an error.

Thanks to Andy, rmackenzie & lotsaram..
Venu.

Hi, I have couple of TI process involved in updating a Dimension on daily basis.. one of them unwinds the hierarchies of dimension and then it fires another TI Process which fires an SQL Query to Oracle Database for the updated values. Another will Construct the Hierarchies, it works fine if Databas...