Search found 62 matches
- Tue Sep 05, 2017 11:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule
- Replies: 3
- Views: 3423
Rule
Hope somebody could throw a light on my misunderstanding: I try to implement a spreading procedure and first of all I want to have an indicator for changes at all (by rule). I attached a picture showing the cube, the attributes cube assigned to the main cube and the rule: ['Changed',{'A','B'},'Expen...
- Wed Aug 23, 2017 4:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Retrieving Data using Alternate Hierarchy
- Replies: 7
- Views: 9279
Re: Retrieving Data using Alternate Hierarchy
You could retrieve data in PA2 directly from a MDX view. And MDX supports qualifying particular hierarchies per dimension like [Time].[Calendar].[Year] where Calendar would be one hierarchy beyond others into the Time dimension. MDX views as a TI data source Previously, a view could be created and s...
- Wed Aug 23, 2017 4:15 pm
- Forum: Commercial and Events
- Topic: Ranet OLAP
- Replies: 4
- Views: 23595
Re: Ranet OLAP
Does Ranet Analytics work with TM1 Server as OLAP data source? If yes, limited somehow?
- Wed Aug 23, 2017 4:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HierarchySize Function
- Replies: 4
- Views: 3636
Re: HierarchySize Function
In the PA docs there are many functions supporting the new hierarchy feature, maybe this could do the job?
As far as there is a subset ALL in place for the regraded hierarchy...
Code: Select all
HierarchySubsetGetSize(DimName, HierName, SubsetName);
- Wed Aug 23, 2017 11:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 'Flipping' Element and Alias in Accounts Dimension
- Replies: 12
- Views: 10671
Re: 'Flipping' Element and Alias in Accounts Dimension
With 10.2.0 it works fine.
- Tue Aug 22, 2017 9:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tracking User Logins
- Replies: 19
- Views: 22255
Re: Tracking User Logins
Sorry for the late feedback. I tried it without a path: Defined logfile was created into the folder where the tm1slog.properties resides (same as TM1s.cfg). But empty. So generally the triggering works somehow under the hood, but not the entry of the log event. Then I tried the style with double bac...
- Fri Aug 04, 2017 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tracking User Logins
- Replies: 19
- Views: 22255
Re: Tracking User Logins
You mean I need to switch on the auditing function to get system logging? That leads to "game over" for me. I reside in Germany, and if I would activate auditing (which logs much more than just logins...) I would at least get serious trouble with the working council (and probably commit a ...
- Fri Aug 04, 2017 1:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tracking User Logins
- Replies: 19
- Views: 22255
Re: Tracking User Logins
Unfortunately my typo only occured in the post, but not in the filename... this would have been easier :lol: I used lotsarams script, but faced the same experience: Log-file (userlogin.log) will be created after saving the file changes for ....properties. Then starting Perspectives, logging in, logg...
- Thu Aug 03, 2017 3:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tracking User Logins
- Replies: 19
- Views: 22255
Re: Tracking User Logins
I tried the way using the log4j logger. Generally, it works as the TM1llogin.log-File was created immediately. But when I log in to that server, the file keeps empty. Do I have to maintain some different switches somewhere to get some content into that file? The tm1slog.properties resides now in the...
- Thu Aug 03, 2017 2:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need Help in coding
- Replies: 5
- Views: 3542
Re: Need Help in coding
First of all you should prepare your metadata in advance, preferably outside of TM1. For example using an ETL-Tool (like Pentaho PDI or Talend). Or at least via Excel. Then you could import this preferably via a process (or for prototyping also by copy and paste from Excel). Don't forget to read as ...
- Wed Jul 26, 2017 5:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tracking User Logins
- Replies: 19
- Views: 22255
Re: Tracking User Logins
If I don't configure the interval very narrow, I would have always a lack of actuality. If I configure it to update frequently, IBM warns about problems. Is there any way to trigger it proactive somehow? The docs don't indicate that, but maybe I use the wrong search terms. I mean to configure the in...
- Wed Jul 26, 2017 5:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: where to find active clients
- Replies: 4
- Views: 3938
Re: where to find active clients
Another useful dynamic subset in the Clients dimension is the current user. {StrToMember("[}Clients].["+USERNAME+"]")} Thank you, very nice. But I have to admit that I'm wondering, what kind of syntax the part USERNAME is. I don't find it somewhere in the manuals. Is it a synony...
- Wed Jun 28, 2017 6:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VLOOKUP not working on TM1Web
- Replies: 3
- Views: 4292
Re: VLOOKUP not working on TM1Web
For me it worked even not with a restricted (named) range.
TM1 10.2.0 FP3, and, indeed, it is the german version of Excel 2013 I use for development.
But on the server is installed english version of Excel 2010.
Could the different versions of Excel cause additional malfunctions?
TM1 10.2.0 FP3, and, indeed, it is the german version of Excel 2013 I use for development.
But on the server is installed english version of Excel 2010.
Could the different versions of Excel cause additional malfunctions?
- Thu Jun 22, 2017 12:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Flow Diagram
- Replies: 8
- Views: 7350
Re: Data Flow Diagram
Here it comes: yED4.png (graph below neighbourhood above: In the graph "proc2" was clicked, which leads to the extracted view above) Obviously it's not a kind of automatic analysis of metadata, but as I document my own framework continously, it helps tremendous to indicate, which Processes...
- Thu Jun 22, 2017 11:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Flow Diagram
- Replies: 8
- Views: 7350
Re: Data Flow Diagram
The topic is a little older, but just to share another possible solution to this: I solved it for my own purposes using yED: https://www.yworks.com/products/yed You can prepare a adjacence matrix in Excel, open this Excel file with the yED editor and point it to the matrix. It will build a .graphml-...
- Mon Jun 19, 2017 2:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Cube Optimization (performance and Size
- Replies: 1
- Views: 2897
Re: TM1 Cube Optimization (performance and Size
I found this presentation quite nice: https://www.google.de/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwiDwf2risrUAhUKJlAKHcCBAwcQFggnMAA&url=http%3A%2F%2Fwww.canrocksolutions.com%2Fwp-contest%2Fuploads%2F4.Canrock-Solutions-Major-Principles...
- Mon Jun 19, 2017 2:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1top SSL Cognos Express v10.2
- Replies: 2
- Views: 2700
Re: Tm1top SSL Cognos Express v10.2
This guy works at IBM on the SSL challenge and helped me with a last issue very well:
http://www.tm1forum.com/memberlist.php? ... le&u=12742
Also note the DW-thread at IBM: https://www.ibm.com/developerworks/comm ... a4e33e6e8c
http://www.tm1forum.com/memberlist.php? ... le&u=12742
Also note the DW-thread at IBM: https://www.ibm.com/developerworks/comm ... a4e33e6e8c
- Mon Jun 12, 2017 8:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Time dimension, alternate drill-down path
- Replies: 7
- Views: 5478
Re: Time dimension, alternate drill-down path
Here the result in the Subseteditor: TM1_DIM_DATE_ALT_NAV_PATH_Pic4.png It seems like I could add only max. 3 pictures per post... Note, that I prefixed the year level members (CY for calendar year, CW for calendar week, so furtherly the derived variable is used). When I left the years as they were ...
- Mon Jun 12, 2017 8:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Time dimension, alternate drill-down path
- Replies: 7
- Views: 5478
Re: Time dimension, alternate drill-down path
You need to prepare a data source for this having a PK for each granular item and for each level an identifier also as a label value (in my case it's an import via ODBC/SQL): TM1_DIM_DATE_ALT_NAV_PATH_Pic1.png Then you define this PK as an element and all other identifiers as Consolidation (my pic s...
- Wed May 31, 2017 5:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: FIFO in TM1
- Replies: 2
- Views: 2952
Re: FIFO in TM1
I would think of a mixup of both measures like interest (with negative sign) and payment (kept with positive sign) to be generalized as accounting transactions. Then ordering this by time and making a cumulation per transaction, similar as my bank is doing in my account statements. After each iterat...