Search found 1631 matches

by Wim Gielis
Fri Apr 20, 2018 5:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get string from log file ?
Replies: 1
Views: 246

Re: How to get string from log file ?

Hello Process this file in Turbo Integrator as a text file data source. The Metadata and Data tab of the process will allow you to write code to act on each line of the file. Typical functions to use will be Scan, Subst, Delet, and then of course DimensionElementInsert, CellPutN/S, CellIncrementN, ....
by Wim Gielis
Thu Apr 19, 2018 8:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 5
Views: 362

Re: TI Function ViewMDXGet Not Working

ptownbro wrote:
Wed Apr 18, 2018 8:31 pm
I'm using Version 10.2.2
Then this functionality is too new for your environment.
by Wim Gielis
Wed Apr 18, 2018 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 5
Views: 362

Re: TI Function ViewMDXGet Not Working

What version of TM1 / Planning Anaytics do you have ?
by Wim Gielis
Tue Apr 17, 2018 4:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Query on SwapAliasWithPrincipalName
Replies: 2
Views: 178

Re: Query on SwapAliasWithPrincipalName

Use this function in the Prolog tab, not the Data tab.
It’s done for the entire dimension.
For elements outside the subset, use the same element name in the alias.
by Wim Gielis
Tue Apr 17, 2018 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Scripting
Replies: 3
Views: 187

Re: TM1 Scripting

Add a function in the Prolog. DimensionSortOrder
by Wim Gielis
Mon Apr 16, 2018 5:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Logs - Access Rights Required
Replies: 6
Views: 288

Re: Transaction Logs - Access Rights Required

chewza wrote:
Mon Apr 16, 2018 7:09 am
Will need to see if there is a loop through log files, and dynamically change the test file source. Not sure if this can be done in Tm1,
Why not ? Use Wildcardfilesearch and DataSourceNameForServer.
by Wim Gielis
Fri Apr 13, 2018 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 5
Views: 383

Re: How to generating a text file using Control cube?

Hello,

Is this a recurring task ?
I would advise to create an Active form, with clients and groups in the rows, zero-suppressed.
This will give you the list, which can be "saved as" with a text file format if needed.

A TI process is also possible.
by Wim Gielis
Tue Apr 10, 2018 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 354

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

If you have a data source, like a relational table or flat file, then probably in the Metadata tab.
If it's elements that you insert as a one-off and not through a data source, it would go in the Prolog tab.
by Wim Gielis
Mon Apr 09, 2018 8:19 pm
Forum: Useful code, tips and tricks
Topic: Checking the data source of a TI process
Replies: 0
Views: 226

Checking the data source of a TI process

Hello all, In the category... the nicer TI processes :-) Attached is a generic process to check for the data source of a TI process . You know, text files, ODBC connections, cube views, dimension subsets, and so on. The tests for the text files (CHARACTERDELIMITED files) are the most elaborate: - do...
by Wim Gielis
Mon Apr 09, 2018 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Rule in }ElementSecurity_Dimension
Replies: 2
Views: 133

Re: Help on Rule in }ElementSecurity_Dimension

You can use the function ELISANC in the rule to determine the relations between the elements, and hence give READ access.
by Wim Gielis
Mon Apr 09, 2018 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SAP BW and TM1 through Cognos BI
Replies: 1
Views: 108

Re: SAP BW and TM1 through Cognos BI

And 2 more screenshots:
03.png
03.png (46.05 KiB) Viewed 106 times
and
04.png
04.png (66.88 KiB) Viewed 106 times
by Wim Gielis
Mon Apr 09, 2018 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SAP BW and TM1 through Cognos BI
Replies: 1
Views: 108

SAP BW and TM1 through Cognos BI

Hi all, At a major TM1 site where I spend a good deal of my time, they have SAP ECC, SAP BW and this is coming to TM1 through the use of both: 1. Cognos BI (which dumps data extracts from SAP BW queries overnight into text files) 2. the TM1 Package Connector, straight to SAP BW. Both metadata and da...
by Wim Gielis
Mon Apr 09, 2018 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Performance Tuning
Replies: 2
Views: 213

Re: TI Performance Tuning

What is the data source of the process when you use the Metadata tab ?
by Wim Gielis
Fri Apr 06, 2018 5:05 pm
Forum: Useful code, tips and tricks
Topic: Inspecting views
Replies: 5
Views: 1001

Re: Inspecting views

Sophie Kay wrote:
Thu Apr 05, 2018 8:17 am
It's great that I came here ...
Glad you like it !

I have a number of changes to the code, somewhere in the near future I can post an update.
by Wim Gielis
Thu Apr 05, 2018 7:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add new dimension to existing cube
Replies: 5
Views: 349

Re: Add new dimension to existing cube

Very good answer Paul !
paulsimon wrote:
Wed Apr 04, 2018 9:49 pm
Perhaps there is a genius out there who can export the lot to JSON using the TM1 Rest API and parse it to do all the replacements
I have seen this in TI but it’s not my work so can’t give it out.

Wim
by Wim Gielis
Wed Apr 04, 2018 3:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add new dimension to existing cube
Replies: 5
Views: 349

Re: Add new dimension to existing cube

Is there any other way to proceed? Yes, the manual way. Consult documentation on the model, if any. Do this on a development server first. Backup cube data, rules, views (if needed), cube security and cell security settings (if any), cube properties, and so on, since you need to delete the cube (or...
by Wim Gielis
Wed Apr 04, 2018 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible to pass parameters to a powershell (.ps1) file?
Replies: 13
Views: 710

Re: Is it possible to pass parameters to a powershell (.ps1) file?

vino1493 wrote:
Wed Apr 04, 2018 3:13 am
@Orlando Thanks for your reply, this can be done for .exe files not .ps1, I guess I will have to hard code.
Where did you read that ?
by Wim Gielis
Tue Apr 03, 2018 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get all SQL from TI processes
Replies: 4
Views: 372

Re: Get all SQL from TI processes

From the 'Useful code, tips and tricks' section:

http://www.tm1forum.com/viewtopic.php?f=21&t=13373

Note that the Prolog tab can still overwrite certain settings like the one in 566 and 562.
So you need to take that into account as well.
by Wim Gielis
Fri Mar 30, 2018 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service restart times
Replies: 2
Views: 560

Re: TM1 service restart times

Thank you Declan.