Search found 211 matches

by Mark RMBC
Tue Jan 28, 2020 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter according to attribute of current user
Replies: 2
Views: 113

Re: MDX filter according to attribute of current user

Hi,

How about:

Code: Select all

{FILTER({[Organisation].Members}, [Organisation].currentmember.name = StrToMember ( "[}Clients].[" + UserName + "]" ).properties("Department"))}
regards,
Mark
by Mark RMBC
Mon Jan 27, 2020 3:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBR/DBRW formulas resulting in #VALUE! errors
Replies: 8
Views: 110

Re: DBR/DBRW formulas resulting in #VALUE! errors

One of those occasions where you swear you are going mad!

My money would have been on cell B5, out of interest how exactly was that cell formatted, the cell that held Jan-2010?

regards,

Mark
by Mark RMBC
Tue Jan 14, 2020 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issues with 2 row dimensions in Active form
Replies: 3
Views: 514

Re: MDX Issues with 2 row dimensions in Active form

Hi, I can't think of an mdx workaround. If these forms are NOT being consumed in TM1 web you could insert a column to DBRW to the category lookup cube and apply custom validation (Unfortunately custom validation does not appear to work in TM1web) on whether the DBRW returns Y, so only allow none zer...
by Mark RMBC
Mon Jan 13, 2020 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issues with 2 row dimensions in Active form
Replies: 3
Views: 514

Re: MDX Issues with 2 row dimensions in Active form

Hi, It would be nice to know which dimensions are in your 2 .lookup cubes. Just looking at your category mdx statement (the second one), there is no reference to the category dimension in the mdx? It would appear to be pointing at the KPI dimension? Incidentally: I do not think what you are trying t...
by Mark RMBC
Mon Jan 13, 2020 9:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 522

Re: TM1 MDX in TI Process

Hi, I managed to get this work in a fashion, i.e. to asciioutput where the FTE = 0 and the Bonus Rate > 0. The problem comes with the string element, i.e. Action element. Under no circumstances could I get it to ascii where FTE = 0 and Action <>"" Incidentally I found the following to be more robust...
by Mark RMBC
Thu Jan 09, 2020 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 522

Re: TM1 MDX in TI Process

Hi,

So you have the dimensions category, company, department, division, employee and measure in your cube
and your MDX refers to only the employee and measures dimension? Also your Action measure is a string.

I am surprised the MDX returns the correct values under those circumstances.

regards,
Mark
by Mark RMBC
Thu Jan 09, 2020 10:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX Dynamic Form FILTERBYPATTERN MDX
Replies: 0
Views: 82

PAX Dynamic Form FILTERBYPATTERN MDX

Hi Folks, In the grand old days of perspectives I was able to build an active form with the option to do a wildcard search, to do this I ensured the alias was populated in the TM1RPTROW and then the mdx part of the TM1RPTROW would reference a cell. The mdx would be something like: ="{TM1Sort(TM1Filt...
by Mark RMBC
Tue Dec 03, 2019 5:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 4921

Re: MDX - dynamic subset to filter by two other dimensions

Hi James,

no worries, tbh without planningdev I wouldn't have got there either!

Just for my sanity, what were the tweaks you made?

regards,
mark
by Mark RMBC
Tue Nov 19, 2019 1:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Filtering on StrMember
Replies: 4
Views: 224

Re: MDX Filtering on StrMember

Sorry misread that! You want to get the attribute value for Oct-2019! How about? FILTER({TM1FILTERBYLEVEL({TM1SUBSETALL([Periods-Months])}, 0)}, [Periods-Months].[TM1 Last Day Serial Date] >= StrToMember("[Periods-Months].[" +[Global Variables].([Global Values].[Value],[Global Variables].[LACT])+ "]...
by Mark RMBC
Tue Nov 19, 2019 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Filtering on StrMember
Replies: 4
Views: 224

Re: MDX Filtering on StrMember

Hi Tomok,

it would be easier if the global value was numeric, but how about:

FILTER({TM1FILTERBYLEVEL({TM1SUBSETALL([Periods-Months])}, 0)}, [Periods-Months].[TM1 Last Day Serial Date] >= strtovalue([Global Variables].([Global Values].[Value],[Global Variables].[LACT])))

regards, mark
by Mark RMBC
Thu Nov 14, 2019 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 4921

Re: MDX - dynamic subset to filter by two other dimensions

Ha! Thanks PlanningDev, I get it. I think you are correct about the and statements, but I tried the following and it seemed to work: StrToSet( IIF(Instr(1, [GLOBAL Level].CurrentMember.Name, 'All Levels', 1) >0 or Instr(1, [GLOBAL Mode].CurrentMember.Name, 'All Modes',1) >0, "{TM1SubsetAll([Course])...
by Mark RMBC
Wed Nov 13, 2019 5:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 4921

Re: MDX - dynamic subset to filter by two other dimensions

Hi PlanningDev,

Maybe you can explain where in the MDX Mode=PT AND level=LevelA is referenced because it is confusing me! :?
by Mark RMBC
Wed Nov 13, 2019 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Optimize While
Replies: 20
Views: 707

Re: Optimize While

I don't think gTonkins long hand method will work here given I think this is spreading the same value to multiple cells, so if my understanding is correct the problem looks as follows: Source Cube: 2019 AreaA SectionD 100 2019 AreaA SectionE 200 Destination Cube: 2019 AreaA SectionD SubSectA 100 201...
by Mark RMBC
Thu Nov 07, 2019 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 4921

Re: MDX - dynamic subset to filter by two other dimensions

Hi, I am slightly confused, which may well be me! What does the cube have anything to do with this, that is what I am struggling with. When you say Global Level and Global Mode are both title dimensions in this cube, which cube? And in reality Global Level and Global Mode are both just dimensions ar...
by Mark RMBC
Thu Nov 07, 2019 1:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 4921

Re: MDX - dynamic subset to filter by two other dimensions

Hi, I haven't quite worked out what Global Level or Mode is, a subset, a single element in a dimension of one element? I don't think the UNION is the issue personally. Have you tried doing something like just to check it returns something: {UNION( StrToSet( IIF( [GLOBAL Level].CurrentMember.Name<>"A...
by Mark RMBC
Fri Oct 25, 2019 1:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF function return undefined type Error
Replies: 9
Views: 5871

Re: IF function return undefined type Error

It would also help if example 1 had the correct number of parenthesis!
by Mark RMBC
Fri Oct 18, 2019 9:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Compare Development and Production Server
Replies: 5
Views: 3955

Re: Compare Development and Production Server

Every developer will hate me for saying this, I hate me for saying this, but good quality documentation and audit of any changes would, in theory, reduce the need to have to compare both environments. So if you document all changes you should just have to refer to the document to see where dev and p...
by Mark RMBC
Tue Sep 10, 2019 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrated Login
Replies: 7
Views: 2017

Re: Integrated Login

Hi,

no progress yet, got as far as you really. Have parked this at the mo due to other priorities but will be back on it at some point.

I will let you know how I get on!

regards, Mark
by Mark RMBC
Mon Sep 09, 2019 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrated Login
Replies: 7
Views: 2017

Re: Integrated Login

Hi gtonkin,

I noticed your steps were for 10.2, before I look into this, do you think all those steps are still relevant for planning analytics?

regards, Mark
by Mark RMBC
Mon Sep 09, 2019 8:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrated Login
Replies: 7
Views: 2017

Integrated Login

Hi, I am trying to create integrated login. I have managed to get architect and perspectives to work (Just click on the server and it lets you in). However with mode 2 when prompted for a user name and password, I can no longer login manually using my windows id and password, my windows password doe...