Search found 3007 matches

by lotsaram
Tue Oct 16, 2018 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 9
Views: 218

Re: When is a "hierarchy" not a hierarchy

To that end, I much prefer the term "consolidation" to "rollup". Why? Because for the foreseeable future there will continue to be a little button named "Rollup" which has a distinctly different functionality to an actual "everyone with security access can see it and use it" consolidation. I disagr...
by lotsaram
Tue Oct 16, 2018 9:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Learning TM1
Replies: 6
Views: 685

Re: Learning TM1

If you want to learn how to create a new model from scratch then by far the best built in documentation is the "Rules Guide". The only TM1 textbook I would recommend is this one https://books.google.ch/books/about/IBM ... kgCWfgg5EC
by lotsaram
Tue Oct 16, 2018 6:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput - Measures across top
Replies: 8
Views: 1659

Re: ASCIIOutput - Measures across top

This is great stuff and I got it to work. However, currently I have 275+ variables I need to create. These variables may change and/or expand to 300+ in the future. Is there an automated way to create a variable within the process? I have set everything up in Excel as to the naming of the variable,...
by lotsaram
Fri Oct 12, 2018 5:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web form date issue - PA 2.0
Replies: 2
Views: 186

Re: TM1 web form date issue - PA 2.0

I have a defect raised for this one.
"[PH01736] TM1 Web date picker overwrites DBR cell with plain value"

Sounds like the same issue to me.
by lotsaram
Tue Oct 09, 2018 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 180

Re: Drill-through to a cube view

It would of course be great if we could change the view name in the returnviewhandle function. As I often find the last 10% of the design and implementation of the functionality can remove large amounts of possible use cases for the functionality. Well you can. Our standard approach (workaround) is...
by lotsaram
Tue Oct 09, 2018 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax DBRW() function
Replies: 5
Views: 235

Re: Tm1 pax DBRW() function

PAX is more strict than Perspectives in terms of error value vs. blank for not existing cell intersections.
You can use conditional formatting to make the font the same colour as the cell background.
by lotsaram
Tue Oct 09, 2018 5:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 9
Views: 218

Re: When is a "hierarchy" not a hierarchy

Dimension is still needed, not everything is a hierarchy. It's possible to have dimensions and no hierarchies, but you can't have hierarchies without dimensions. This is kinda the point. No it's not like that. In Planing Analytics all dimensions have hierarchies . You can't in fact have a dimension...
by lotsaram
Mon Oct 08, 2018 9:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 180

Re: Drill-through to a cube view

Hi Wim,

This bug seems to have been there for a while. IMO it's harmless as it is just a display issue. As long as the user is directed to the correct target view layout with the correct element son filter and subsets on rows & columns that's what really matters.
by lotsaram
Mon Oct 08, 2018 9:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: returnviewhandle
Replies: 4
Views: 191

Re: returnviewhandle

daniel.havassy wrote:
Mon Oct 08, 2018 7:28 am
One area where you'd encounter it is drill-through to a TM1 cube view. The drill TI process would have that as a statement in Epilog.
by lotsaram
Sun Oct 07, 2018 5:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 12
Views: 825

Re: TI Function ViewMDXGet Not Working

As I said already you can’t convert a traditional view to a MDX view with ViewMDXSet. The view type is immutable.
by lotsaram
Fri Oct 05, 2018 6:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection
Replies: 8
Views: 140

Re: TM1 10.2.2 FP4 on Windows 10 - Subset editor items disappear when using multi-selection

This bug has been there for a while (happens in dimension editor too). As it is in Perspectives/Architect I'm not holding out any hope of it being addressed.
by lotsaram
Thu Oct 04, 2018 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 12
Views: 825

Re: TI Function ViewMDXGet Not Working

Traditional MDX views saved as .vue files (created by user in architect or with TI ViewCreate function) aren't MDX based and wil of course return blank string for MDX value. This function will only return MDX string for views created in Workspace or other rest API based client like Arc or created wi...
by lotsaram
Wed Oct 03, 2018 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 9
Views: 218

When is a "hierarchy" not a hierarchy

OK so this has been bothering me for a while. When discussing dimension structure (particularly with other “oldschoolers”) the term hierarchy is often (mis)-used to describe internal ancestor-grandparent-parent-child relationships as opposed to the "textbook definition" of a dimension hierarchy in t...
by lotsaram
Tue Oct 02, 2018 10:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Service Strange Behaviour
Replies: 5
Views: 115

Re: Service Strange Behaviour

I don't really get what you mean. When an instance starts the }chores, }cubes, }dimensions, }processes (& }applicationentries) dimensions are all updated based on the file contents of the data directory. So when you say When the service starts no processes are being loaded in to memory yet the }proc...
by lotsaram
Tue Oct 02, 2018 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset not found in dimension
Replies: 4
Views: 101

Re: Subset not found in dimension

Thanks Lotsaram. In the case of alternative hierarchies in PAW, does this imply that with ViewCreateByMDX we need to write (difficult) MDX expressions ? Help files on this function: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_viewcre...
by lotsaram
Tue Oct 02, 2018 9:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset not found in dimension
Replies: 4
Views: 101

Re: Subset not found in dimension

Are you using alternate hierarchies? If yes then you need to use ViewCreateByMDX as this is the only way to address hierarchies in a view as the traditional views are not hierarchy aware. ViewCreate can only create a traditional view which can't see hierarchies. You either need to use the same named...
by lotsaram
Mon Sep 24, 2018 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How should I do it? I want to modify the rules without anyone using TM1.
Replies: 3
Views: 901

Re: How should I do it? I want to modify the rules without anyone using TM1.

I recall a post but cannot track it down, suggesting that a good way to lock CAM/AD users out while work is going on is to change IntegratedSecurityMode from 5 to 1. This TM1S.CFG is dynamic in PA 2 at least (not I believe in TM1 10.x) https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com...
by lotsaram
Wed Sep 12, 2018 4:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy as a Datasource
Replies: 2
Views: 197

Re: Hierarchy as a Datasource

It works just fine. The trick is to set the hierarchy as the dimension source with DatasourceNameForServer variable with the hierarchy's "full name" as it appears in }Dimensions. You can't use just the hierarchy name and have to concatenate the dimension name with colon as hierarchy names aren't uni...
by lotsaram
Tue Sep 11, 2018 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Attribute Functions
Replies: 11
Views: 266

Re: Hierarchy Attribute Functions

To further clarify, you would add attributes to a dimension so that you can store attribute information about the elements within that dimension. To store attribute information about hierarchy names, you don't add attributes to dimension:hierarchy, you have to add them to the dimension that has dim...
by lotsaram
Tue Sep 11, 2018 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Attribute Functions
Replies: 11
Views: 266

Re: Hierarchy Attribute Functions

PavoGa wrote:
Mon Sep 10, 2018 9:56 pm
Okay, got what I wanted by using "Caption" as the alias attribute. Wish this was a little more flexible, but can make this work.
The Caption attribute doesn't have to be an alias, it can also be a text attribute. (But is does have to be called "Caption".)