Search found 1748 matches
- Mon May 23, 2022 6:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder issue... Can someone help
- Replies: 9
- Views: 3695
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...
- Mon May 23, 2022 4:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: about TI process commit error
- Replies: 2
- Views: 1015
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...
- 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: 1147
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...
- 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: 1146
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...
- 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: 941
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 ...
- 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: 13609
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.
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.
- 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: 2229
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.
That's new information to me - I don't like the same MDX in different tools producing different results.
- 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: 2229
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 ...
- 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: 2229
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...
- 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: 2229
Re: MDX wildcard filter based on cube value
You can use INSTR e.g.:
INSTR documentation: https://docs.microsoft.com/en-us/sql/md ... rver-ver15
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
- 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: 1013
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...
- Thu Apr 14, 2022 8:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to select a given number of elements from the dimension?
- Replies: 2
- Views: 752
- Tue Apr 12, 2022 6:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Learning TM1 / Planning Analytics
- Replies: 10
- Views: 3456
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...
- 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: 8583
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 ...
- 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: 1813
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...
- 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: 1707
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...
- 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: 774
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 ...
- 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: 941
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...
- 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: 1301
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...
- 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: 5056
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...