Search found 22 matches

by jpm_de
Fri Mar 03, 2017 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct URL for a Contributor Application
Replies: 3
Views: 2674

Re: Direct URL for a Contributor Application

Hiding long URLs of (email) links?
This is the most basic feature of a hyperlink, although I agree, that an object name would be crisper.
by jpm_de
Fri Feb 17, 2017 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 8143

Re: How to Use DBSW

True, I mainly see DBS and DBSW in heritage solutions, or solutions built by or for pre-TI folks. Using rules or TI is faster and more reliable, e.g. to do simulations or to limit typical Excel cell slips. Nevertheless, in some cases, there is some complex Excel logic involved, which you might not w...
by jpm_de
Tue Jan 10, 2017 2:31 pm
Forum: Enhancements
Topic: RFE 66823-Compare Base to one or more Sandbox scenarios
Replies: 2
Views: 3316

Re: RFE 66823-Compare Base to one or more Sandbox scenarios

I still agree with gtonkin when it comes to utilizing sandboxes more easily.

I found this video of Planning Analytics Workspace, which shows how the new (virtual) Hierarchies functionality is leveraged for Sandboxes:
https://www.youtube.com/watch?v=rj-aVE2YQeI
by jpm_de
Fri Sep 09, 2016 2:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hold Consolidate and Hold Release in TI
Replies: 6
Views: 3936

Re: Hold Consolidate and Hold Release in TI

Actually, I came across a user requirement, where centrally/automatically administering holds is exactly, what the client might need. And yes, you could and should train users to use holds. Power users will love this feature during the prep or adjustment of any initial/final plan. But setting holds ...
by jpm_de
Wed Mar 16, 2016 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Breakback on rule calculated cells
Replies: 4
Views: 1540

Re: Breakback on rule calculated cells

Hi there, Honestly, this EP functionality for a set of simple rules in combination with holds would be a nice enhancement for TM1. A good example of generic enhancements I was hoping for, when they started to "integrate" EP functionality. EP has some nice BiFs, which on the other hand are very limit...
by jpm_de
Wed Dec 09, 2015 4:54 pm
Forum: Enhancements
Topic: RFE 66823-Compare Base to one or more Sandbox scenarios
Replies: 2
Views: 3316

Re: Compare Base to one or more Sandbox scenarios

CAFÉ Flex views allow for this feature, as the sandbox is the top-most "element".
So at least for Excel Power users it is already in place.

And with CAFÉ being the future of Perspectives, I am hoping to see the same in new front-ends such as Planning Analytics as well...
by jpm_de
Wed Dec 09, 2015 11:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatically Expand Active Form Two Levels
Replies: 11
Views: 4290

Re: Automatically Expand Active Form Two Levels

OK, one big step forward: Using the supported MDX function DRILLDOWNLEVEL I am getting, what I wanted: Within my example: DRILLDOWNLEVEL( {[Hierarchy Example].[Root]}) results in Root and A, B, C. And I can easily nest the function as often as I want to drill to a deeper level, e.g. to MDX Level 4: ...
by jpm_de
Wed Dec 09, 2015 10:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatically Expand Active Form Two Levels
Replies: 11
Views: 4290

Re: Automatically Expand Active Form Two Levels

Exactly, TM1 FILTERBYLEVEL returns the TM1 level you ask for. I hoped and tried FILTERBYLEVEL , but in vain, TM1 does not know this function. At least not documented and I did not find a correct syntax. Having a ragged hierarchy, on top with a varying depth, it is quite hard to determine, what to as...
by jpm_de
Tue Dec 08, 2015 6:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatically Expand Active Form Two Levels
Replies: 11
Views: 4290

Re: Automatically Expand Active Form Two Levels

In relation to the topic: I tried the (adjusted) code and it did not work for me. Maybe, because I do have a ragged hierarchy, that is 10 levels deep at most. Two questions of things I do not understand yet: 1. What is the benefit/intention of {TM1FILTERBYPATTERN( {TM1SUBSETALL( [MLOC] )}, "MGMT - A...
by jpm_de
Tue Dec 08, 2015 5:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter by Attribute
Replies: 5
Views: 1486

Re: Filter by Attribute

Hi there, To start working with TM1's MDX functionality, you should take a look at this document: Creating Dynamic Subsets in Applix TM1 with MDX - A Primer http://bihints.com/book/export/html/68 And keep in mind, that you can do a lot of stuff with TM1, so there might be other ways (than the one's ...
by jpm_de
Tue Dec 08, 2015 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Windows 10 - Anyone Taken The Plunge Yet?
Replies: 9
Views: 3329

Re: Windows 10 - And what about MS Edge?

Hi there,

Has anybody tested the new Microsoft browser MS Edge as well?

Thank you very much, any helpful comment is highly appreciated :D
by jpm_de
Thu Sep 10, 2015 9:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Load Balancing
Replies: 9
Views: 4037

Re: TM1 Web Load Balancing

http://www-01.ibm.com/support/docview.w ... wg21671642

Maybe, the TM1 Web part is interesting... (and Application Web to old Enterprise Planning customers?)
by jpm_de
Sat Jun 27, 2015 3:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2 TM1 Top
Replies: 7
Views: 4108

Re: 10.2 TM1 Top

Well, officially it is not supported, but, has it ever been?
An educated guess: It was labeled out-dated to promote Operations Console, which is quite nice.
by jpm_de
Wed Jun 24, 2015 6:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Potential PI issue with Dimension Updates
Replies: 6
Views: 2871

Re: Potential PI issue with Dimension Updates

Yeah, I would love to see some best practice classes and documents. Well, people tend to need to learn a lot of things the hard way ;-D I came across these topics, when I was designing a master process management concept to get a more flexible chore management functionality. By the way, I am wonderi...
by jpm_de
Thu Feb 28, 2013 10:01 pm
Forum: Commercial and Events
Topic: Tm1 books
Replies: 32
Views: 20444

Re: Tm1 books

They have launched a Kindle edition of the official guide.

IBM Cognos TM1 The Official Guide - Kindle Edition

I am very impressed by the influence, Alan Kirk seems to have :D
by jpm_de
Fri Mar 02, 2012 1:20 pm
Forum: Commercial and Events
Topic: Tm1 books
Replies: 32
Views: 20444

Re: Tm1 books

There is a new and first official TM1 book available, including thoughts on the newly released V10.1!

http://www.amazon.com/IBM-Cognos-TM1-Of ... =pd_cp_b_0

Great book with superb value for money.
by jpm_de
Thu Oct 06, 2011 9:56 pm
Forum: Enhancements
Topic: Optional MDX parameter for the SUBNM function
Replies: 1
Views: 1971

Optional MDX parameter for the SUBNM function

What I would suggest is a MDX parameter for the SUBNM function, the way it is implemented as an optional parameter within the TM1RPTROW function. That would be a very powerful possibility to circumvent dynamic subsets and would allow for easy user-/data-specific frontend interaction, too. This would...
by jpm_de
Tue Oct 04, 2011 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web/Perspectives inconsistencies
Replies: 2
Views: 928

Re: TM1 Web/Perspectives inconsistencies

Although it might be obvious: Have you tried to reboot your (TM1, web, etc. ) server, the corresponding services and Excel? Very uncommon, but I once had a caching problem resulting in a shift of values to the next dimension element. Do you use aliases? There had been TM1 Web issues with that in 9.4...
by jpm_de
Thu Jan 13, 2011 1:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Print Error on TM1Web
Replies: 4
Views: 3148

Re: Print Error on TM1Web

There is an official IBM technote, that might help as well.
The suggested solution didn't work for me, but it may help in other cases.

http://www-01.ibm.com/support/docview.w ... wg21455239

Best regards,
JPM
by jpm_de
Fri Aug 27, 2010 3:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms - Different Filters for Different Columns
Replies: 3
Views: 1663

Re: Active Forms - Different Filters for Different Columns

Hi there, I do have a similar question. I do have an active form with two column blocks, one that shows year-to-date KPIs and another block that shows total-to-date KPIs. That way I got a mix of 17 values of two dimensions (KPI, TIME with year-to-date and total-to-date consolidations). Along with so...