Search found 1748 matches

by declanr
Wed Oct 12, 2022 7:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cases where MDX is a better alternative to cube rules
Replies: 9
Views: 2351

Re: Cases where MDX is a better alternative to cube rules

I use it all the time to display values from 1 cube alongside an input view for another cube with some related dimensions. No point in duplicating data in various points across a model, if the purpose is just to present something to a user for info then I tend to try and do it in the presentation la...
by declanr
Thu Oct 06, 2022 9:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Books - Default Books as landing page for different users
Replies: 4
Views: 1005

Re: PAW Books - Default Books as landing page for different users

Hi, Yes, at the moment there is no default redirect to a landing page from the PAW url for different users. Each book does however have its own URL, that you can take from the "Share" options. So you can have users save that as a shortcut to navigate to instead of using the main URL. Thank...
by declanr
Fri Sep 30, 2022 12:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 PAW - Exploration view - Insert calcul on 2 dimensions
Replies: 22
Views: 3601

Re: TM1 PAW - Exploration view - Insert calcul on 2 dimensions

I presume you are talking about PAW? If so, I would be interested to know how you would avoid the calculation appearing twice in the view if there are 2 dimensions at play? MDX Views can be used in PAW and in PaFE explorations. For Explorations in PaFE you get the "Exploration" subsection...
by declanr
Fri Sep 23, 2022 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI takes more time to complete on user sandbox than on Base
Replies: 2
Views: 2215

Re: TI takes more time to complete on user sandbox than on Base

Hi, Running a TI process against a sandbox shouldn't have significant differences to running against the base data - on the assumption that it's processing roughly the same data. What is possibly happening here is that the particular sandbox being executed against has user inputs which result in a s...
by declanr
Thu Sep 15, 2022 9:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Groups using IntegratedSecurityMode=5
Replies: 1
Views: 603

Re: TM1 Groups using IntegratedSecurityMode=5

Where are you looking? You are correct that TM1 can use both types of groups at the same time, but "local" TM1 groups won't be visible in Cognos. Any group created in TM1 will be visible only in TM1, in the }Groups dimension and relevant cubes e.g. }CubeSecurity. The }Groups dimension will...
by declanr
Thu Sep 15, 2022 9:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 4327

Re: ASCIIOutput Elements in One Dimension Only

As I have understood your requirement: You want to produce a file with 25 columns: - Column 1 = Project Code - Column 2>13 = Revenue for Month 1 through to 12 - Column 14 > 25 = Expenditure for Month 1 through to 12 And you want to exclude any Project/Row where all of the 24 values are zero. Unless ...
by declanr
Tue Sep 13, 2022 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: POW workspace specific Picklist
Replies: 3
Views: 628

Re: POW workspace specific Picklist

PAW doesn't have any special way of defining picklists, it works the same way across all interfaces. However, in all interfaces, a picklist that is defined via a picklist CUBE (this will show in control objects as }Picklist_<Your Cube Name> ) will always take priority over anything you define with a...
by declanr
Sat Sep 10, 2022 9:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Spreading - Stop after certain months
Replies: 3
Views: 816

Re: Data Spreading - Stop after certain months

In PAW you can highlight the cells you want to be part of the spread and then use the right-click spread option, this will let you do all spreading options except "relative xxx" I believe. You don't have to select right, up, down, or left as you have already defined the area to be included...
by declanr
Tue Sep 06, 2022 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web data writeback is slow!
Replies: 6
Views: 1301

Re: TM1web data writeback is slow!

If it’s just a small training server I would hazard a potential guess that the physical server it’s sat on doesn’t have much RAM - and if you hit that limit it will start paging to disk instead which could cause it to be very slow. So to add to things to check - RDP to the physical server and check ...
by declanr
Mon Sep 05, 2022 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web data writeback is slow!
Replies: 6
Views: 1301

Re: TM1web data writeback is slowly!

Hi, As Elessar has pointed out it could be locking that causes this, but I assume this wait happens every time? If so it is unlikely that you are in a wait state every time... unless it's a high user concurrency system and/or there are TIs scheduled to constantly run against the view in question. th...
by declanr
Fri Aug 19, 2022 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: picklist solution in tm1
Replies: 6
Views: 1185

Re: picklist solution in tm1

['Priority Types']=S:IF(!Demand Type @='Structural', subset:Priority Types:pcklist,""); rule is not saved and throwing an error that rule is having the logical error. please suggest. You mentioned that "Demand Type" will also be selected by users as a picklist. So instead of pul...
by declanr
Mon Aug 08, 2022 7:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form reports not generating ending columns PA 2.0.9.14 & PA 2.0.9.13
Replies: 7
Views: 1561

Re: Active Form reports not generating ending columns PA 2.0.9.14 & PA 2.0.9.13

If you add additional columns outside of an active form you need to update the named range TM1RPTFMTRNG to include your new columns. This tells TM1 to dynamically update the relevant rows it adds in under that column when the form is refreshed/rebuilt.
by declanr
Thu Aug 04, 2022 10:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Spread Failed For Some Users With Access
Replies: 8
Views: 1619

Re: Data Spread Failed For Some Users With Access

1/ When the users are facing the issue - can they not do ANY data spreading or can they only not do it in certain cubes / cube intersections? 2/ When the users are facing the issue - have you tested performing the exact same spread with another account that has the "same" access - and was ...
by declanr
Thu Aug 04, 2022 10:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OdbcOutput Update and Insert
Replies: 2
Views: 721

Re: OdbcOutput Update and Insert

Hi, There will be many different ways to do this and it is partially dependent on the DB you are using (e.g. Oracle, SQL Server etc.) That being said, generally, in cases like this, I would do a straight Insert/Bulk Update to a temp table in the DB and then use a MERGE to transfer data from the temp...
by declanr
Wed Jun 29, 2022 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IIF Mdx in IBM PAW not compiling
Replies: 5
Views: 1710

Re: IIF Mdx in IBM PAW not compiling

{StrToMember ( "[Dim_Measure].[" + IIF ( [Scenario].CurrentMember.Name = "Elem1", "MeasureA", "MeasureB" ) + "]")} Generally speaking, IIF should be inside of other functions that will return either a SET or MEMBER. Think of it as the results of the...
by declanr
Mon Jun 20, 2022 7:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Administration - Agents & Email Alert Config
Replies: 1
Views: 785

Re: PAW Administration - Agents & Email Alert Config

The agent needs to be installed on all of the TM1 servers for PAW to be able to monitor them. You can download the agent from PAW, and then go to a TM1 Server and install it. The fact that you can already see an agent for your TM1 server means that you already have one installed, so you probably don...
by declanr
Wed Jun 15, 2022 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Admin tool - Pointing to New Tm1 Servers
Replies: 3
Views: 809

Re: PAW Admin tool - Pointing to New Tm1 Servers

And is there perhaps an old paw.ps1 file that still has the old configuration? As I mentioned it's just a guess but the containers could still be associated with an old directory. And try running ./scripts/paw.ps1 in powershell with admin rights - this should force any configuration changes to be ap...
by declanr
Wed Jun 15, 2022 10:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Admin tool - Pointing to New Tm1 Servers
Replies: 3
Views: 809

Re: PAW Admin tool - Pointing to New Tm1 Servers

What does the paw.ps1 file in the config folder show? It should be exactly the same as what you see in the admin tool GUI since that will be where it retrieves the details it shows you is from. My guess with the info you have provided would be that you actually have kept multiple PAW folders/directo...
by declanr
Sun Jun 12, 2022 6:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connecting to TM1 server using Global IP address?
Replies: 2
Views: 864

Re: Connecting to TM1 server using Global IP address?

Theoretically, with the ports open it should be possible. However, it would very likely be so slow that it would not be at all useable. The old clients (Architect & Perspectives) are EXTREMELY chatty over a network which is why Citrix, VPN etc was always the norm. If you try using them over a WA...
by declanr
Wed May 25, 2022 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Maintenance in PAW or TI?
Replies: 9
Views: 1770

Re: Hierarchy Maintenance in PAW or TI?

Line 1: "Q2 23 vs Q2 22","","0" Line 2: "Q2 23","Q2 23 vs Q2 22","1" line (2): Dimension Element "Q2 23 vs Q2 22" not numeric. I expect what you have here is for Line (2) - you are using a ComponentAdd to make "Q2 23" a...