Search found 160 matches

by garry cook
Fri Feb 12, 2021 2:55 pm
Forum: Enhancements
Topic: Shared Sandboxing
Replies: 3
Views: 2824

Shared Sandboxing

This periodically raises its head and I've just had another use case come up again for shared sandboxes. Just went to raise a ticket but on checking before posting, saw that someone had already raised a ticket with a handful of votes. It's showing as "Future consideration" currently which is ironic ...
by garry cook
Wed Jan 20, 2021 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Actionbutton with more than one line
Replies: 4
Views: 634

Re: Actionbutton with more than one line

Other option to render appropriately in TM1Web specifically is to do it in reverse and create a fully transparent Action button sized the same as the background image. Place this over the background image you want to use if you're dynamically changing the background icon or underlying text, etc. Use...
by garry cook
Thu Jul 23, 2020 8:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Insertion to HANA Performance
Replies: 4
Views: 1364

Re: ODBCOutput Insertion to HANA Performance

For reference for anyone who comes across this on a search in the future, the solution to this was Hana syntax for the batching as follows: INSERT INTO "dummyname"."dummyname" select NOW(),'blah','blah','blah','blah','blah','',-5.781 from dummy union select NOW(),'blah','blah','blah','blah','blah','...
by garry cook
Mon Jun 15, 2020 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Insertion to HANA Performance
Replies: 4
Views: 1364

ODBCOutput Insertion to HANA Performance

Running into an issue with awful performance pushing data from PA Cloud into HANA via Remote Gateway. Raised a ticket with IBM but reaching out to the hive mind also as suspect this is more to do with our HANA syntax knowledge. Overview of Process: Prolog: ODBCOpen Data: ODBCOutput using SQL Insert ...
by garry cook
Mon Nov 25, 2019 9:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New monitor
Replies: 7
Views: 2122

Re: New monitor

Hi Wim, I use a 4k monitor pretty much exclusively for work and perspectives renders fine at 4k resolution. I use perspectives daily on a 32" 4k without issue so shouldn't be a concern. For ref, 27" is just about the minimum size I'd personally recommend if you're going 4k. I found smaller screens s...
by garry cook
Fri Jul 12, 2019 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandboxes in Dynamic Reports?
Replies: 8
Views: 2968

Re: Sandboxes in Dynamic Reports?

Thanks Wim, much appreciated. Was in a bit of a brain dump mode there so didn't articulate well but the core issue I've got with it when I say I can't fix is to re-enable the menu key functionality rather than the specific use case of the special value. That's probably the most common example along ...
by garry cook
Fri Jul 12, 2019 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandboxes in Dynamic Reports?
Replies: 8
Views: 2968

Re: Sandboxes in Dynamic Reports?

The biggies are covered above by lotsa. On a lesser scale, the following are user QoL issues off the top of my head that I find very annoying. I'll caveat first to say two things: - 1) Perspectives is tired and lacking by modern standards. PAx is heading in the right direction and will eventually be...
by garry cook
Wed Jul 10, 2019 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandboxes in Dynamic Reports?
Replies: 8
Views: 2968

Re: Sandboxes in Dynamic Reports?

I literally came across this last week when doing some budget what-if scenarios. To my knowledge, PAx doesn't have native support for sandboxing in the same way Perspectives did by having a dropdown switch although I'd love to be proven wrong if anyone knows otherwise. If you export a sandbox based ...
by garry cook
Thu Oct 04, 2018 8:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 10
Views: 3339

Re: When is a "hierarchy" not a hierarchy

Could not agree more, a difficult but important habit to break.
by garry cook
Fri Jul 27, 2018 6:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - FilterByPattern on Attributes
Replies: 3
Views: 1750

Re: MDX - FilterByPattern on Attributes

Fair enough - thanks for the conf Wim, much appreciated.

KR

PS I like to keep the { }'s for the sake of my own sanity when checking the syntax!
by garry cook
Thu Jul 26, 2018 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - FilterByPattern on Attributes
Replies: 3
Views: 1750

MDX - FilterByPattern on Attributes

Someone asked me today how to pull a wildcard search against an attribute in MDX. I must be getting rusty (I blame Tableau and PowerBI) as this turned out to be a bit more long winded than I thought and I ended up sticking at the following rather obtuse statement - in this case returning Employees w...
by garry cook
Tue Jan 09, 2018 3:49 pm
Forum: OLAP Jobs
Topic: TM1 Perm UK Guildford / Sheffield Role
Replies: 0
Views: 13263

TM1 Perm UK Guildford / Sheffield Role

I'm looking for a permanent role to work in my team with a heavy focus on TM1 based here in the UK in either Guildford or Sheffield so PM me if you're interested and I can point you to the job ad. It's a senior developer role with an expectation to spec and technically lead projects so both the tech...
by garry cook
Thu Nov 17, 2016 9:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Data Underneath ruled cells 10.2.2 FP6
Replies: 2
Views: 1888

Re: String Data Underneath ruled cells 10.2.2 FP6

Have you tried setting RulesOverwriteCellsOnLoad in the config? Seen this kind of behaviour with string data before in earlier versions and brought up the server with this on to purge the underlying data which worked fine (can't remember which version - possibly as far back as 9.5.2). Remember to tu...
by garry cook
Fri Jun 10, 2016 7:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with intercube feeders
Replies: 1
Views: 1410

Re: Help with intercube feeders

['3rd Quarter','Incentive']=C: The rule you have is calculating at a C (consolidated) level only so you will either need to feed the data beneath the consolidation in order for TM1 to recognise that the consolidation needs to be fed or make sure that there is data in one of the children. Is the C l...
by garry cook
Thu May 19, 2016 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Editing code... your preferred way?
Replies: 13
Views: 6489

Re: Editing code... your preferred way?

Remembering to press CTRL-C twice to copy text! Yes, it still catches me out... I'm forever pasting 'something else' because Architect refuses to let me have it on the first time of asking. Can't remember who first raised this so apologies for the lack of credit but if you roll the C on a Ctrl+C it...
by garry cook
Mon May 16, 2016 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Chart Title
Replies: 4
Views: 2411

Re: Dynamic Chart Title

Annoyingly not in 10.2.2.2 - 10.2.2.4 - had dynamic lookups for Product Group names mapped from string cube hierarchy points and had to go with the low tech option of putting the title in an Excel cell fitted to the graph floating above the graph. Doesn't look great but did the job - dynamic name ch...
by garry cook
Fri Mar 18, 2016 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: .blb and .rux files - maintenance
Replies: 12
Views: 6921

Re: .blb and .rux files - maintenance

The TM1 server exclusively uses the .RUX files as the definitive source of rule statements. Any .BLB files are artifacts created by the client application (in this case performance modeller). Typically they store things like additional formatting details, etc... It is worth pointing out though inca...
by garry cook
Fri Mar 04, 2016 11:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives
Replies: 17
Views: 8195

Re: TM1 Perspectives

I genuinely cannot let this one go. I've been a member of this forum and it's predecessor for over a decade and have not come down hard on a post until this point. The issue is that this is not the kind of query where someone has been dropped into a difficult situation looking for help or a particul...
by garry cook
Wed Jan 20, 2016 8:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [SOLVED] Unable to get value of the property 'split': object is null or undefined
Replies: 6
Views: 5067

Re: Unable to get value of the property 'split': object is null or undefined

We went from 10.2.2 SP2 to SP4 on our dev server just before Xmas and haven't seen any issues such as the clearing of cache however we strongly suggest to users that they access via Firefox / Chrome rather than IE as we've seen a number of random rendering issues with IE over SP1 / 2 / 4 cycle. Has ...
by garry cook
Tue Nov 17, 2015 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing "Export / Slice to Excel" option from Web
Replies: 2
Views: 2076

Removing "Export / Slice to Excel" option from Web

Been looking into removing this option for exactly the reasons found here.

My hopes aren't high but thought it would be worth a check to see if anyone has managed to find a workaround to bypass the classic "It's on the Roadmap!" response? Client is 10.2.2.

TIA