Search found 141 matches

by JamiseBondi
Tue Nov 29, 2022 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating indented snapshots from cube views
Replies: 6
Views: 1000

Re: Creating indented snapshots from cube views

Wim Gielis wrote: Tue Nov 29, 2022 12:54 am I typically stick to some VBA code, organized in the ribbon. Clean and neat, doesn’t require a Nobel prize to set up.
Thanks Wim, so you're making use of either perspectives or PAX then? I was after a workaround for tm1web, but thanks for the tip.
by JamiseBondi
Tue Nov 29, 2022 7:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating indented snapshots from cube views
Replies: 6
Views: 1000

Re: Creating indented snapshots from cube views

Are you simply asking the WHY or are you asking if there's a workaround? I'm not aware of a fix. As for the why, my guess is it has to do with Perspectives being an excel add-in and TM1web using open xml file format for excel files since 10.2 and IBM not being bothered to consider that as desired f...
by JamiseBondi
Mon Nov 28, 2022 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating indented snapshots from cube views
Replies: 6
Views: 1000

Creating indented snapshots from cube views

Hi guys, Could anyone explain why when a dimension hierarchy viewed in a cube view in perspectives is snapshotted out to excel this hierarchy is maintained (indentations are preserved). When this same cube view is viewed from tm1web, the hierarchy is visible, but when snapshotted out from the cube v...
by JamiseBondi
Wed Jul 06, 2022 10:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modify default TM1web layout
Replies: 8
Views: 2029

Re: Modify default TM1web layout

Hi, PRODUCT_NAME :"IBM® Planning Analytics 2.0.9", ABOUT_STR :"About", HELP_TOOLTIP_STR :"Help", LOG_OUT_STR :"Log Out", On windows installation for PAL 2.0.9 you can find this "magic words" in the file <installation path>\webapps\tm1web\scripts\tm1...
by JamiseBondi
Wed Jul 06, 2022 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modify default TM1web layout
Replies: 8
Views: 2029

Re: Modify default TM1web layout

Short of direct editing the source files in the install location that would then get overwritten any time you upgrade, I'm not aware of how to do this. I guess you could create a custom browser extension that dynamically updates the html of the page for all users. You could even build your own cust...
by JamiseBondi
Wed Jun 22, 2022 6:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modify default TM1web layout
Replies: 8
Views: 2029

Modify default TM1web layout

Hi guys, Is it possible to modify the existing layout of TM1web such that you can hide certain banners or buttons i.e. to change the default layout of tm1web as it's rendered in a browser. For example. the 'banner' that contains "IBM Cognos TM1Web on the left and on the RHS is .... Help | Logou...
by JamiseBondi
Fri Nov 05, 2021 10:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opinions & Best Practices for Front-end Design
Replies: 7
Views: 14350

Re: Opinions & Best Practices for Front-end Design

The clipboard functionality exists but you'll require a plug-in for newer browsers. (this will need installing on each machine your accessing tm1web/workspace from https://www.ibm.com/support/pages/plugins-microsoft-edge-mozilla-firefox-and-google-chrome-web-browsers-are-available-use-copy-and-past...
by JamiseBondi
Tue Jul 27, 2021 5:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Jmeter setup
Replies: 8
Views: 8847

Re: Jmeter setup

Thanks Mike! much appreciated.
by JamiseBondi
Mon Jul 26, 2021 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Jmeter setup
Replies: 8
Views: 8847

Re: Jmeter setup

Hi guys, I know this is an old thread, but I'm interested in getting Jmeter running to monitor my instances in real-time, rather than load testing a website. If you look on slide 6 of 29 on this site, it explains we need both the visualizer and wrapper jar files to be able to monitor the server acti...
by JamiseBondi
Mon May 31, 2021 9:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: passing excel variable into MDX
Replies: 2
Views: 2081

Re: passing excel variable into MDX

Thank you Wim,

I was trying to insert a single inverted comma, but excel didn't like " ' "
I used your example of " " " and it worked.
Much appreciated!
by JamiseBondi
Fri May 28, 2021 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: passing excel variable into MDX
Replies: 2
Views: 2081

passing excel variable into MDX

Hi guys, I've used the following format in the past to get a variable in excel passed into an MDX statement successfully. ="{FILTER ( {TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dimension1] )}, 0)}, ASC)} , [CC_Config].([Version].[&CHAR(34)&$F$15&CHAR(34)&],[CC].[HQ],[}ElementA...
by JamiseBondi
Mon Apr 19, 2021 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW on Windows server 2019
Replies: 10
Views: 7964

Re: PAW on Windows server 2019

Makes for an interesting read. So how many of you guys are running PAW on windows 2016 in a production environment... successfully and painlessly? I was told that IBM had a plan for a dockerless version of PAW, and that was due for release in Q4 of 2019, then was delayed to Q2 of 2020, then Covid ap...
by JamiseBondi
Mon Aug 10, 2020 10:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: High Availability PA server
Replies: 4
Views: 2670

High Availability PA server

Hi guys, I've seen a post by IBM describing a high availability PAW application layer cluster where a distributed architecture of web servers is used to spread the load behind a load balancer. (https://na.eventscloud.com/file_uploads/b16ad176a58e3a9a360d66f1a4009c4e_Plan_IBMPlanningAnalyticsLocal_So...
by JamiseBondi
Wed Jan 30, 2019 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA: Multiple web instance
Replies: 8
Views: 4856

Re: PA: Multiple web instance

Hello, with TM1 10.2 it was very easy to create a second TM web instance (copy the war rename it, tomcat extract the war, make settings, restart tomcat- done). With Planning Analytics and webphere this doesn't work. Even Copy the TM1Web Folder in WebApps,rename and restart does not work. Does anayb...
by JamiseBondi
Fri Nov 10, 2017 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tool to analyse TM1 web dumps
Replies: 2
Views: 2481

Re: Tool to analyse TM1 web dumps

Awesome! Thanks Steve. Good to know.
by JamiseBondi
Thu Nov 09, 2017 11:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tool to analyse TM1 web dumps
Replies: 2
Views: 2481

Tool to analyse TM1 web dumps

Hi All, Does anyone here have any suggestions on what tool/s you use to analyse the web dump files that are generated from time to time? These would be core*.dmp heapdump*.phd javacore*.txt I'm just interested to know if there is a tool that would be able to give us an indication of the problem with...
by JamiseBondi
Tue Oct 24, 2017 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create a drillable consolidator with only leaf level children
Replies: 5
Views: 3552

Create a drillable consolidator with only leaf level children

Hi guys, I'm trying to create a dynamic subset that shows a collapsed consolidated node that when expanded, only shows the leaf level children (not any consolidated children). Does anyone have any hints? I've gone through the "MDX a primer" site (http://www.bihints.com/book/export/html/68)...
by JamiseBondi
Tue Jun 27, 2017 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running multiple web processes in TM1 10.3 on websphere
Replies: 0
Views: 1604

Running multiple web processes in TM1 10.3 on websphere

Hi guys, Having installed TM1 10.3 (Planning Analytics Local 2.0.2) I see that the new bundled web server is IBM websphere - Liberty profile. I'm sure there a few of you who have run TM1 web on websphere already. Does anyone know how we can run multiple web processes on the bundled websphere server ...