Search found 2421 matches

by tomok
Tue May 22, 2018 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Query Help
Replies: 2
Views: 62

Re: Query Help

It might be due to the question mark (?) in the query. TM1 could be thinking you are trying to insert a parameter.
by tomok
Mon May 21, 2018 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting started with REST API (issue)
Replies: 7
Views: 169

Re: Getting started with REST API (issue)

Did you literally try this address, http://tm1server:HTTPPortNumber/api/v1/$metadata, or did you substitute in the port number for the "HTTPPortNumber" part of the string?
by tomok
Wed May 16, 2018 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 186

Re: Security Access Flag not being Deployed

FWIW, I have never had to "redo" processes that have security access after deployment. It has always worked for me. I'm pretty sure it is in the .pro file I just can't remember which line it is. It would be easy to figure out: 1) take the security off and save, 2) open the .pro file in Notepad and l...
by tomok
Wed May 16, 2018 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: show recently added elements in subset.
Replies: 5
Views: 119

Re: show recently added elements in subset.

What is your definition of "recently added elements"? Those added overnight from an automated process? Those added by a user since the last time the cube was checked? It's a lot more involved than your simple question. The best way to do this would be to add an attribute on this dimension, as alread...
by tomok
Tue May 15, 2018 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset with Expand Above
Replies: 3
Views: 149

Re: Dynamic Subset with Expand Above

So the way I create this is using dynamic subset, turn on Expand Above, expand all the items and move the "(Net Profit)" from bottom to top. Problem is: after saving it the "(Net Profit)" went back to the bottom. That's because a "dynamic" subset is just that, dynamic. It recalculates itself every ...
by tomok
Thu May 10, 2018 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 6
Views: 596

Re: TM1 Save Data Issue 2.0.4

Can I have one TI and run these chores in an order synchronously . so that one dont start when the previous still runs. So is this possible to do [/b] You can't run a chore from a TI, only other processes. What stopping you from combining everything into one chore so that they are run consecutively...
by tomok
Thu May 10, 2018 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube ViewTo Excel/CSV
Replies: 8
Views: 5184

Re: Export Cube ViewTo Excel/CSV

ASCIIOutPut command can only output text, You'll have to convert v6 to text before you can use it in the formula. When I am Converting Number to string Only one value is converting and i am getting only one value in the output how to change total data to string Read the request for assistance guide...
by tomok
Wed May 09, 2018 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Statement Failed
Replies: 12
Views: 334

Re: SQL Statement Failed

It's not the user YOU are logged on as when defining the query in TM1, it is the account the TM1 SERVICE is running under (assuming you are using SQL Server integrated security). If you take that table out and it works it's probably that the TM1 service account does not have access to that table in ...
by tomok
Mon May 07, 2018 6:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Do rule changes create a log
Replies: 1
Views: 145

Re: Do rule changes create a log

Question for the masses, Do rule changes create a log anywhere? Can this be turned on? we are being asked for an audit and I have never come across this or been asked about it before. It can but you have to have audit logging turned on for it to work. It's only going to work going forward so if you...
by tomok
Sat May 05, 2018 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 19
Views: 913

Re: Exporting data from view to file consuming memory

FWIW, these are a waste of time in a TI process as each cell is read as a single record with no concept of context, rows, or columns. These statements are for views you intend to view in the Cube Viewer: # Rows ViewRowDimensionSet(sCubeName, sViewName, 'Product', 1); # Columns ViewColumnDimensionSet...
by tomok
Sat May 05, 2018 10:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing values in TI for sql query
Replies: 4
Views: 184

Re: Passing values in TI for sql query

The question mark "?", is only needed to substitute a parameter for code in the query window. If you build your SQL as a string in the Prolog and then set that as the query with DataSourceQuery variable then you can build the SQL as a string. This is much easier, BTW. Something like this: SQL = 'SEL...
by tomok
Sat May 05, 2018 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: security
Replies: 2
Views: 118

Re: security

There is no concept of a column in TM1. If you mean dimension level security, then yes. Right click on }Dimensions object and choose Security.
by tomok
Fri May 04, 2018 10:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1
Replies: 14
Views: 434

Re: tm1

venureddy wrote:
Fri May 04, 2018 9:53 am
How to overcome that
You're not going to get very far in the TM1 world if you are going to continually wait for someone else to tell you how to do everything. Do you think it may have something to do with the currency sign? Did you try removing it and see if that made a difference?
by tomok
Thu May 03, 2018 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 482

Re: Cube Copy TI Process

The issue is that when you decide to copy a YTD element you are creating a subset with the YTD element instead of the individual months underneath that YTD element. You can't do that because you can't write to a consolidated node, only the leaf elements below it. You need to modify your subset creat...
by tomok
Wed May 02, 2018 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 482

Re: Cube Copy TI Process

Why do you have all the code referring to the year commented out?
by tomok
Wed May 02, 2018 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 482

Re: Cube Copy TI Process

Add a parameter two parameters to your process, pSourceMonth and pTargetMonth. Then create a subset in both the source and target views and add the new parameter elements to those subsets. This will narrow it down to just the single month.
by tomok
Wed Apr 18, 2018 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 5
Views: 437

Re: TI Function ViewMDXGet Not Working

The link you pasted is for the the documentation from PA2.0. I've never used that function so I'm pretty sure it's not available in 10.2.2, unless it's in one of the last fix packs.
by tomok
Fri Apr 13, 2018 2:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 6
Views: 511

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

Nobody is going to write your code for you. Basically you create a TI process and select Cube as the data source and then you select default as the view. Then in the data tab you use the TI function ASCIIOUTPUT to write what is in the Value field from the view to a text file. It's pretty simple. An ...
by tomok
Thu Apr 12, 2018 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 19
Views: 913

Re: Exporting data from view to file consuming memory

"Garbage" memory isn't really garbage. It can and will be consumed by TM1 as long as the service is up. The only thing it can't be used for is other apps on the box and you shouldn't be housing more then TM1 on one box in the first place.
by tomok
Wed Apr 11, 2018 4:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"
Replies: 6
Views: 260

Re: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"

ok, will this fix also my issue how application is calling tm1web? I don't know what you are talking about. and is it possible to set the same DNS twice for MyNewName.MyCompany.com:9510/tm1web/ and MyNewName.MyCompany.com:9510/pmpsvc/ Setting a DNS entry just serves as a substitute for the IP addre...