Search found 95 matches
- Fri Jul 23, 2021 9:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Opening websheet in new tab in TM1Web (not browser)
- Replies: 4
- Views: 3269
Re: Opening websheet in new tab in TM1Web (not browser)
Are the users able to manually open 2 tabs at the same time? If not it could be the hidetabbar option is set in either the config file or the }clientsettings cube. Thanks for pointing me in the right direction here. I have managed to resolve it by specifying this config parameter explicitly & s...
- Fri Jul 23, 2021 9:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Opening websheet in new tab in TM1Web (not browser)
- Replies: 4
- Views: 3269
Re: Opening websheet in new tab in TM1Web (not browser)
Hi Declan,
They are able to open two different browser tabs, and navigate to say sheet 1 and sheet2 respectively. Is that what you meant?
Thanks
Kaz
They are able to open two different browser tabs, and navigate to say sheet 1 and sheet2 respectively. Is that what you meant?
Thanks
Kaz
- Thu Jul 22, 2021 6:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Opening websheet in new tab in TM1Web (not browser)
- Replies: 4
- Views: 3269
Opening websheet in new tab in TM1Web (not browser)
Hi everyone, We are evaluating Planning Analytics Local 2.0.9.1 in test environment, while our production is on 2.0.4. We have links to various websheets that are accessed by action buttons. In production, upon clicking an action button, the websheet is opened in a new tab within TM1Web in the same ...
- Mon Oct 05, 2020 4:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unexpected behavior of consolidations
- Replies: 8
- Views: 3181
Re: Unexpected behavior of consolidations
Hello Kaz, Setting a c-level rule, as you do for PNL00000Q, does not impact higher-lever consolidations, in this case PNL00000H or PNL00000D, as those also consolidate leaf-level elements. You’ll need to use ConsolidateChildren , but this gets messy. Thanks for the response. I was hoping to avoid C...
- Fri Oct 02, 2020 8:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unexpected behavior of consolidations
- Replies: 8
- Views: 3181
Unexpected behavior of consolidations
Hi guys, I have a multi level hierarchy in my management account dimension, as shown in Subset with hierarchy image. 1.2 Subset with hierarchy.png PNL00000Q should be a calculation of ABS( PNL000068 ) - ( PNL000067). This is working okay. However the parents of PNL00000Q,PNL00000D and PNL00000H leve...
- Sun Dec 08, 2019 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Devops in PA/TM1
- Replies: 9
- Views: 6648
Re: Devops in PA/TM1
Although not free, Pulse (by Cubewise) has all monitoring, deployment and change control tools you need. Also, their Arc product is good for writing code (snippets, auto-indent etc). Likewise, I used Rest API for hot promotion, although not extensively. Furthermore, I have got a few PowerShell scri...
- Thu Sep 12, 2019 1:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules replicating itself
- Replies: 4
- Views: 2434
Re: Rules replicating itself
Sure, I see you want skipcheck and feedstrings to be the first statements to avoid any doubts.
But this was an odd scenario.
But this was an odd scenario.
- Thu Sep 12, 2019 12:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules replicating itself
- Replies: 4
- Views: 2434
Re: Rules replicating itself
My normal structure is
#notes
skipcheck;
feedstrings;
rules ;
feeders;
Thanks
kaz
#notes
skipcheck;
feedstrings;
rules ;
feeders;
Thanks
kaz
- Thu Sep 12, 2019 10:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules replicating itself
- Replies: 4
- Views: 2434
Rules replicating itself
Hi everyone, I am on Planning Analytics Local, 2.04, and use Architect. I ran into a weird scenario yesterday where rules in one of my TM1 cubes replicated themselves. My rules looked like below; #create date #notes skipcheck; feedstrings; rule 1 ; rule 2 ; rule 3 ; feeders; feeder for rule 1 ; feed...
- Fri Feb 08, 2019 10:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sorting consolidations dynamically
- Replies: 4
- Views: 2746
Re: Sorting consolidations dynamically
Thanks Wim and Tom. @Wim, I tried setting order of the elements, but they get blown away as soon as the overnight process loads data and re-assign children to their respective parents. @Tom, my data loading process has multiple processes. I am adding Current, New Work, and Not Used as children of Al...
- Mon Jan 21, 2019 6:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sorting consolidations dynamically
- Replies: 4
- Views: 2746
Sorting consolidations dynamically
Hi everyone, I am trying to sort the following consolidations ; Capex-projects-consol-sorting-issue.png I want 'All Not Used' to be listed before 'All New Work', and I have tried variations of DimensionSortOrder function but I am not having any luck, certainly I am doing something incorrect. What's ...
- Tue Oct 02, 2018 11:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Missing tm1 section from server.xml - PAL, TM1Web, Integrated login
- Replies: 2
- Views: 2244
Re: Missing tm1 section from server.xml - PAL, TM1Web, Integrated login
Thanks, I shall give it a shot.
So, basically, absence of tm1 tag wouldn't make a difference?
So, basically, absence of tm1 tag wouldn't make a difference?
- Tue Oct 02, 2018 9:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Missing tm1 section from server.xml - PAL, TM1Web, Integrated login
- Replies: 2
- Views: 2244
Missing tm1 section from server.xml - PAL, TM1Web, Integrated login
Hi everyone, I am working on configuring integrated login for TM1 Web, Planning Analytic v2.04 using https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_tm1_ug_configuring_sso_with_spnego.html from IBM. I was at the step 4 where yo update server.xml fi...
- Fri Feb 23, 2018 3:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display element alias using TM1RPTRow and MDX
- Replies: 15
- Views: 8197
Re: Display element alias using TM1RPTRow and MDX
At first sight, this should work. Can you create a view in the cube viewer with the alias turned on and your MDX expression, then Active form to Excel and see if that works ? Hi Wim, That does work. Following is the MDX for RptRow, where {AR} is a hidden worksheet containing static element names fr...
- Thu Feb 22, 2018 5:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display element alias using TM1RPTRow and MDX
- Replies: 15
- Views: 8197
Re: Display element alias using TM1RPTRow and MDX
Here are the functions and the MDX that i am using TM1RPTROW($C$8,"FinancePlan:Line of Business","",,"Code and Description",0,$D$22) TM1RPTView in cell $c$8: TM1RPTVIEW("FinancePlan:Line of Business:Plan:1", 0, TM1RPTTITLE("FinancePlan:Line of Business:Sy...
- Wed Feb 21, 2018 8:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display element alias using TM1RPTRow and MDX
- Replies: 15
- Views: 8197
Re: Display element alias using TM1RPTRow and MDX
tried TM1Rpt and tried specifying the alias in Alias parameter after Subset parameters. Didn't work. Then you didn't do it right. It's best to use the function editor in Excel (click on the little fx icon next to the formula bar). This keeps you from specifying the parameters in the wrong order. Hi...
- Tue Feb 20, 2018 11:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display element alias using TM1RPTRow and MDX
- Replies: 15
- Views: 8197
Re: Display element alias using TM1RPTRow and MDX
Hi Wim
I did, and indeed tried TM1Rpt and tried specifying the alias in Alias parameter after Subset parameters. Didn't work.
Perhaps it's worth mentioning that my Active Form skills are quite limited.
I did, and indeed tried TM1Rpt and tried specifying the alias in Alias parameter after Subset parameters. Didn't work.
Perhaps it's worth mentioning that my Active Form skills are quite limited.
- Tue Feb 20, 2018 9:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display element alias using TM1RPTRow and MDX
- Replies: 15
- Views: 8197
Display element alias using TM1RPTRow and MDX
Hi guys,
Is it possible to display element alias when using MDX within TM1RptRow in Active Forms? I know that we are able to display aliases when using a subset within TM1RptRow instead of MDX.
Is it possible to display element alias when using MDX within TM1RptRow in Active Forms? I know that we are able to display aliases when using a subset within TM1RptRow instead of MDX.
- Tue Sep 05, 2017 3:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives button disabled TM1 10.2.2 & Excel 2016
- Replies: 5
- Views: 4666
Re: Perspectives button disabled TM1 10.2.2 & Excel 2016
I actually did a full upgrade to 10.2.2 FP7 yesterday. I didn't see this at all. This was after a fresh install of Office 2016 as well. Are you sure you've installed the correct version? You haven't installed the 64 bit version of the client on a 32 bit version of excel? Jim. Thanks for the reply J...
- Fri Sep 01, 2017 2:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives button disabled TM1 10.2.2 & Excel 2016
- Replies: 5
- Views: 4666