Search found 1790 matches

by Wim Gielis
Mon Oct 15, 2018 11:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput - Measures across top
Replies: 10
Views: 1736

Re: ASCIIOutput - Measures across top

I guess you mean copy-paste from Excel ? Yes, that would be an absolutely fantastic idea. You can also have a look at the Expand function, possibly linked to looping over a dimension of measure names (or aliases, whichever works best).
by Wim Gielis
Mon Oct 15, 2018 4:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Learning TM1
Replies: 6
Views: 775

Re: Learning TM1

Do you inherit a TM1 model that you need to support ?
Or are you required to set up a new model ?
by Wim Gielis
Tue Oct 09, 2018 4:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes_ not updated with attributes
Replies: 6
Views: 406

Re: }ElementAttributes_ not updated with attributes

Whenever you have an alias set on a dimension and you have one or more alias values that are the same as the elements then TM1 will not accept those values in the }ElementAttributes_ cube. There were still be a value for the alias, like when toggle the alias on and off, but the cube will be empty f...
by Wim Gielis
Tue Oct 09, 2018 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 184

Re: Drill-through to a cube view

! Of all the combinations we tried I don't think we tried that one. TYVM! Hi Steve, But I did, see the first post of this topic. Instead of If( 1 = 0 ); I used: If( 'TM1' @= 'slow' ); and luckily this gives False as the result :lol: i experimented with a Datasource type equal to None, or to Cube vi...
by Wim Gielis
Mon Oct 08, 2018 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting the last date of a month in TI
Replies: 10
Views: 235

Re: Getting the last date of a month in TI

Good idea to use FormatDate and ParseDate ! I'm a fan of these. ParseDate and FormatDate can be really useful if the pattern of the dates can change. We do not necessarily rely upon yyyy-mm-dd and we are much more free in terms of input and output formats. For the last day of the prior month, we sub...
by Wim Gielis
Mon Oct 08, 2018 8:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting the last date of a month in TI
Replies: 10
Views: 235

Re: Getting the last date of a month in TI

To me the easiest solution, with regular TM1 date functions, are as follows. The last day of the current month : # 2018-10-08 sDate = Today(1); # 21488 (= 43404 - 21916) nLastOfTheMonth = DayNo( Dates( Year( sDate ) + If( Month( sDate ) = 12, 1, 0 ), If( Month( sDate ) = 12, 1, Month( sDate ) + 1 ),...
by Wim Gielis
Mon Oct 08, 2018 3:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 184

Re: Drill-through to a cube view

Okay, thanks Steve. So I tried to do things that were not (meant to be) possible :D However, your scenario does not strike me as very improbable nor impossible. It only takes a couple coworkers working on the same data (cubes) and using the drill down in a non-trivial way - sooner or later one of th...
by Wim Gielis
Mon Oct 08, 2018 3:07 pm
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: 144

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

For me too, I am on 2.0.5 since a while and I don't recall having the seen the problem in a while. In the past it used to be an issue. Also in the Dimension Editor.
by Wim Gielis
Mon Oct 08, 2018 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 184

Re: Drill-through to a cube view

It is clearly a bug. The view is not shown, while still be created correctly. The subsets in the rows and columns are shown, but not those in the titles, while still be created correctly. In Architects / Perspectives cube viewer, we could still select the view from the dropdown, even though this sho...
by Wim Gielis
Mon Oct 08, 2018 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: returnviewhandle
Replies: 4
Views: 192

Re: returnviewhandle

daniel.havassy wrote:
Mon Oct 08, 2018 7:28 am
If you are new to drill-throughs, check the product documentation of Planning Analytics, you'll find good explanations there.
Emphasis added.

I happen to be working on drill through to cube views the last 2 days. I don’t find the documentation good in this topic.
by Wim Gielis
Mon Oct 08, 2018 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 184

Re: Drill-through to a cube view

Hello Lotsa, thank you for confirming it’s a bug. However I’m not sure it’s harmless. The subsets in the titles are not picked up. I will test again today to exclude errors on my part. I will also test in a slice with DBRWs.
by Wim Gielis
Mon Oct 08, 2018 3:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 184

Re: Drill-through to a cube view

The drill view statement is: RETURNVIEWHANDLE( pCube_Tgt, c0 ); To make the example more visible, here I added 3 screenshots: 1: the view selection dropdown is empty and the drill view is not selected. Moreover, the 2 row dimensions contain the correct subset (with name and timestamp in it), but the...
by Wim Gielis
Mon Oct 08, 2018 1:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 184

Drill-through to a cube view

Hello all, I am experimenting with setting up a drill-through to a cube view, in Architect. 2.0.5 as the PA version. The scenario is that any cell can be drilled upon and the resulting view contains all descendants of the chosen cell. Like that, we see all numbers that make up the initial number. If...
by Wim Gielis
Sun Oct 07, 2018 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 12
Views: 832

Re: TI Function ViewMDXGet Not Working

Indeed, you would have to extract the MDX from the PA view, interpret / rework it and create a traditional view based on the result.
by Wim Gielis
Sun Oct 07, 2018 10:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 12
Views: 832

Re: TI Function ViewMDXGet Not Working

No. You would have to create a traditional view based on the MDX that you get with ViewMDXGet.
by Wim Gielis
Fri Oct 05, 2018 4:38 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: 144

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

I have experienced this as well, but I have no clue on what causes and resolves this. So I would like to know the answer too ;-)
by Wim Gielis
Fri Oct 05, 2018 4:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting the last date of a month in TI
Replies: 10
Views: 235

Re: Getting the last date of a month in TI

Hello Benoit,

Can you retrieve the first day of the new month in serial number format, subtract 1 and then manipulate the result to get the desired formatted outcome ?
by Wim Gielis
Thu Oct 04, 2018 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 'Set Dimension Order' Not Working
Replies: 13
Views: 1465

Re: TM1 'Set Dimension Order' Not Working

Hello, I found this topic for the same issue, the button "Set Dimension Order" seams not to be working. It does, but you need to save changes to the structure of the dimension before. Arrange your elements. Press "Set Dimension Order" button Save your changes Then only re-open the dim editor and yo...
by Wim Gielis
Wed Oct 03, 2018 7:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements from dimension
Replies: 8
Views: 357

Re: Deleting elements from dimension

Indeed Tom, but in my opinion you have to build up this code step by step. If writing the code to delete an element does not work, then it will definitely not work based on attributes and comparisons and MDX’s. Also I first wanted to see an effort from the OP, like bgregs too I think.
by Wim Gielis
Wed Oct 03, 2018 6:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements from dimension
Replies: 8
Views: 357

Re: Deleting elements from dimension

That function is pretty simple, you can look at the documentation since you have been given the function name: 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_tifun_dimensionelementdelete.html You supply a dimension name and an element na...