Search found 1748 matches

by declanr
Mon May 23, 2022 6:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder issue... Can someone help
Replies: 9
Views: 3427

Re: Feeder issue... Can someone help

With your current rule/feeder set up, it would be assuming that EVERY Employee is performing "Productive Hours" on EVERY Project EVERY Month. In reality, I expect the setup is more realistic that an employee would only work on 1 or a small number of projects in a given month? If that's the...
by declanr
Mon May 23, 2022 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: about TI process commit error
Replies: 2
Views: 989

Re: about TI process commit error

<metadata> i have used dimensionelementinsert function for insert element to dimension first Are you actually using DImensionElementInsert? Or are there "Direct" equivalent functions in there? You *may* be able to clear the error by performing a DimensionUpdateDirect for the dimension, th...
by declanr
Sun May 08, 2022 8:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load time - ODBC vs text file
Replies: 3
Views: 1128

Re: Load time - ODBC vs text file

If you ignore TM1 for a minute. Querying data in a DB will always take some time - if you take the query that you are using for this source and just execute it in a GUI, I expect it will be far from instant in showing you all of the results. Add to this potential network latency between where your D...
by declanr
Sat May 07, 2022 7:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ability to "Read/view access to Chores without ADMIN access
Replies: 2
Views: 1117

Re: Ability to "Read/view access to Chores without ADMIN access

Assigning users read access to a chore *SHOULD* allow them to see it. If they cannot see any chore objects; what interface are they using? - If it's PAW - a user needs to be assigned the Modeller or Admin role to see the Chores etc. - If it's architect - I can't remember this for certain in terms of...
by declanr
Sat May 07, 2022 7:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Save a public cube view and public subset in a Cube without ADMIN access
Replies: 2
Views: 914

Re: Save a public cube view and public subset in a Cube without ADMIN access

What I have done in previous builds - is provide Super Users with access to TIs that utilise the PublishView and PublishSubset TI functions: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=vmtf-publishview https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=smtf-publishsubset This ...
by declanr
Tue Apr 26, 2022 3:59 pm
Forum: Useful code, tips and tricks
Topic: Starting with the REST API - Examples using Excel
Replies: 6
Views: 12787

Re: Starting with the REST API - Examples using Excel

Hi George,

I have so far only had the chance to skim over it - but when time allows I will definitely have a proper look.
On a surface level, it looks like a very thorough explanation for a "starting point"!

Thanks for taking the time to contribute to this.
by declanr
Thu Apr 21, 2022 8:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX wildcard filter based on cube value
Replies: 9
Views: 2154

Re: MDX wildcard filter based on cube value

Just did a quick test. You are right, PAW is completely case insensitive and accepts upper or lower case for INSTR searches.
That's new information to me - I don't like the same MDX in different tools producing different results.
by declanr
Thu Apr 21, 2022 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX wildcard filter based on cube value
Replies: 9
Views: 2154

Re: MDX wildcard filter based on cube value

I found this which actually works very well in PAW but not in PAX. {FILTER([Line].MEMBERS,Instr(1,[Sales_m].[Manager],"bob",1)<>0)} This is interesting - are you sure it is working differently in PAW to PAX? This formula is pretty much the same as what I initially provided, the only real ...
by declanr
Thu Apr 21, 2022 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX wildcard filter based on cube value
Replies: 9
Views: 2154

Re: MDX wildcard filter based on cube value

To cater for lower or upper or any case input by the users you can do 2 things, firstly in another cell in the PAX worksheet have a formula something like =LOWER(A1), let us imagine that is in cell A2. The MDX would then look something like this: ="{FILTER([Line].MEMBERS,Instr(1,LCASE([Sales_m...
by declanr
Thu Apr 21, 2022 7:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX wildcard filter based on cube value
Replies: 9
Views: 2154

Re: MDX wildcard filter based on cube value

You can use INSTR e.g.:

Code: Select all

{ FILTER(
   { TM1SUBSETALL( [Line] ) },
   INSTR([Sales].([Sales_m].[Manager]), "Bob") >0
)}

INSTR documentation: https://docs.microsoft.com/en-us/sql/md ... rver-ver15
by declanr
Mon Apr 18, 2022 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Calculation - Catch All Rule?
Replies: 4
Views: 988

Re: TI Process Calculation - Catch All Rule?

Struggling a little bit to follow exactly, but can you share a bit about where this code is in the TI process? One theory is that if your code is on the data tab and being triggered more than once AND if "Other" is a child of "Control Total" - then on its first run it could put i...
by declanr
Tue Apr 12, 2022 6:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Learning TM1 / Planning Analytics
Replies: 10
Views: 3261

Re: Learning TM1 / Planning Analytics

Also I wanted to ask - @20 Ton Squirrel I'm currently in the process of beginning to study ACCA. Looking at current TM1 jobs, most seem to ask for ACCA or accountancy qualifications as being desirable. Also alot of TM1 users seem to have an accountancy qualification under their belt. Do you think I...
by declanr
Tue Apr 12, 2022 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding TM1 memory usage a bit more
Replies: 8
Views: 8498

Re: Understanding TM1 memory usage a bit more

Hello, Is there an easy formula to understand TM1 memory usage ? I thought it should be something like: Memory Used (}StatsForServer) = Total Memory Used (}StatsByCube) + Memory in Garbage (}StatsForServer) Am I missing something ? I haven't tried it, but I doubt you would ever manage to match the ...
by declanr
Wed Mar 23, 2022 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: An interesting point that I found when updating the "Current Version" thread. (PAW and Windows Server 2019)
Replies: 5
Views: 1719

Re: An interesting point that I found when updating the "Current Version" thread. (PAW and Windows Server 2019)

I did a quick run-through last night, admittedly not a Production system so fairly basic setup. Spun up a 2019 VM and installed PA with basic mode 1 security models. Then installed PAW74 on the same box. Essentially the set up is the exact same as it was for Server 2016, differences were: 1/ From fi...
by declanr
Mon Mar 21, 2022 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Output with delimiters in values
Replies: 1
Views: 1684

Re: ODBC Output with delimiters in values

I can parse out the single and double quote but am unable to remove the comma and what's happening is that the text after the comma is being inserted into the next field. So my sQualifiedString1 is being cutoff at the comma, and the remaining string after the text is being inserted to the account f...
by declanr
Tue Mar 15, 2022 7:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processes that load a reporting cube loads to incorrect server
Replies: 3
Views: 764

Re: TI processes that load a reporting cube loads to incorrect server

In a "standard" set up (if such a thing exists) it is not possible for a TI process to load data into a cube that is not in the same TM1 service that the TI process is running in (e.g. a CellPutN can only update a cube on the service in which the TI is executed.) That being said there are ...
by declanr
Sat Feb 26, 2022 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lifecycle Snapshot - workbook colours all changed
Replies: 1
Views: 935

Re: Lifecycle Snapshot - workbook colours all changed

Are the source and destination servers the same version of PAW? Is the book perhaps using a custom pallet that doesn't exist on the destination server? Which colours are we talking about here: Charts, Conditional Formats etc. There has been a change since the Carbon styling came in that leads to the...
by declanr
Mon Feb 21, 2022 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 web url api mode 5 login page popup all the time
Replies: 3
Views: 1284

Re: Tm1 web url api mode 5 login page popup all the time

It's been a while since I have used the web URL API, but if memory serves it's just a matter of making sure that you pass in the AdminHost parameter exactly the same way it is specified when the users first log in. This is usually the way it is defined in the TM1 Web config file - so even if it is a...
by declanr
Wed Feb 16, 2022 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect Cognos TM1 to MS Power BI
Replies: 17
Views: 4956

Re: Connect Cognos TM1 to MS Power BI

Thanks for your response! I am familiar with Python so that's already something. I would like to create a local TM1 instance to run some tests. Do you know if it's possible to create this without the need to buy and install the IBM Cognos software? You would need to speak to your IBM or Business Pa...