Search found 100 matches

by ascheevel
Fri Jan 17, 2020 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect to Power BI using TM1 Rest api
Replies: 4
Views: 105

Re: Connect to Power BI using TM1 Rest api

Do you get the same error if you just pass "application/json" as the content type header instead of "application/json; charset=utf-8"?
by ascheevel
Thu Jan 16, 2020 5:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To know Active Users & Inactive Users of TM1
Replies: 8
Views: 231

Re: To know Active Users & Inactive Users of TM1

Boom, there goes all there security group assignments. habidullah didn't specify, but if security group assignments are done in Cognos, a user's group assignments would repopulate the next time they log in. Native group assignments would definitely be lost though, hopefully habidullah's friend does...
by ascheevel
Tue Jan 14, 2020 9:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: dynamic shape
Replies: 3
Views: 243

Re: dynamic shape

Did you see the video linked below? I didn't see it linked in the official documentation, but it was in a newsletter I received from IBM this morning.

https://www.youtube.com/watch?v=xe6gqFiRDnM
by ascheevel
Fri Jan 10, 2020 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to load data in cube
Replies: 3
Views: 419

Re: Unable to load data in cube

Are you referring to the ascii output at the bottom of the code you attached? Add your loadvalue variable to that output and reevaluate the outputted file. You'll need to wrap it in NumberToString() function like below. My first guess is your loadvalue variable might be evaluating to zero. asciioutp...
by ascheevel
Tue Dec 17, 2019 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add Elements to own Control Dimension
Replies: 3
Views: 373

Re: Add Elements to own Control Dimension

Check out DimensionElementInsertDirect
by ascheevel
Fri Dec 13, 2019 9:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 480

Re: AsciiOutput element order different from subset

For your test cube, your MDX should look something like the below. I'll try to take a look at your other posted code this weekend.

Code: Select all

ViewCreateByMDX('Cube', 'View',
	'select {[Dim1].[1]} on 0,
	{[DimA].[A]} on 1 from [Cube]'
	);
by ascheevel
Fri Dec 13, 2019 8:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 480

Re: AsciiOutput element order different from subset

kenship wrote:
Fri Dec 13, 2019 8:32 pm

I'm trying to research to use ViewCreateByMDX but the statements couldn't figure out the syntax yet for a MDX view.

If you'd like, post your view details (cube & dim names) including any subset names used and I or someone else on the forum can help with the MDX statement.
by ascheevel
Fri Dec 13, 2019 7:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 480

Re: AsciiOutput element order different from subset

Kenship, is your user info up to date that you're on version 10.2 or have you upgrade to PA 2.0? ViewCreateByMDX is a function that you can use if you're using 2.0 that I believe will keep the element order as you've defined it in the subset. If it doesn't and I'm mistaken, you can add an ORDER stat...
by ascheevel
Thu Dec 12, 2019 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API CAM Authentication - PA (Cloud)
Replies: 8
Views: 412

Re: REST API CAM Authentication - PA (Cloud)

Thanks. Does this method differ from CAM authentication when the installation is on premise ? Put differently, can this only be used for a cloud setup or for all CAM authentication cases ? You can use this method for on-premise as well. For on-premise, you aren't restricted to only using the LDAP n...
by ascheevel
Mon Nov 25, 2019 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Virtual dimensions and Cognos BI
Replies: 3
Views: 3791

Re: Virtual dimensions and Cognos BI

Yes, you can set up hierarchy specific security within PAW. Watch out though if your element security for the dim has rules, you'd want rules that apply to consolidations to be made to be hierarchy specific lest they apply to all hierarchies.
by ascheevel
Tue Nov 19, 2019 10:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count distinct rows
Replies: 2
Views: 298

Re: Count distinct rows

Would I be correct in assuming an invoice could be represented on multiple rows of your transaction file so a simple row count won't work? You could populate a temporary dim in metadata of your import process with the invoice numbers and then do a DIMSIZ in the epilog before deleting the dimension. ...
by ascheevel
Mon Nov 18, 2019 5:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Circular reference in a financial model
Replies: 3
Views: 451

Re: Circular reference in a financial model

Cubewise had a good blog post on working through circular ref in TM1, provides good examples & visuals.


https://code.cubewise.com/blog/resolvin ... alculation
by ascheevel
Mon Nov 18, 2019 3:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Circular reference in a financial model
Replies: 3
Views: 451

Re: Circular reference in a financial model

To be sure, you don't really have a TM1 problem, you have a math problem. Solve the circular ref issue in excel (without iterative calc turned on) and you would solve your problem implementing in TM1. I wasn't a math major, so the attached solution might not be the most elegant, but one way to solve...
by ascheevel
Thu Nov 14, 2019 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to copy paste book from content space (PAW)?
Replies: 1
Views: 224

Re: Is there a way to copy paste book from content space (PAW)?

There's a Save As option in the menu that is to the left of the pencil icon when you open the book.
by ascheevel
Thu Nov 07, 2019 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CSV file as data source, why TI is reading one more column?
Replies: 5
Views: 234

Re: CSV file as data source, why TI is reading one more column?

What harm is variable V13 causing you? You can simply ignore it.
by ascheevel
Thu Nov 07, 2019 4:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx Issue
Replies: 5
Views: 265

Re: PAx Issue

I noticed that on custom and dynamic reports, excel circular references from any open workbook will break refreshes. This jogged my memory. A few months ago, I had a user with the same issue Peter describes and it was circular reference. A circular reference interrupts the calc operation in excel w...
by ascheevel
Thu Nov 07, 2019 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx Issue
Replies: 5
Views: 265

Re: PAx Issue

Did you connect to your TM1 environment via PAX or only open the file? If you connected, what happens when you click the Refresh Sheet or Refresh Book option in the PAX toolbar and not just hitting F9 on your keyboard like you would in Perspectives.
by ascheevel
Wed Nov 06, 2019 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not working
Replies: 6
Views: 746

Re: ExecuteProcess not working

Here is the error messages... You're in the process error messages for your calling process. In the server log, you should see individual ERROR entries for each of those process calls, you can then double-click on one of those to see the details. Alternatively, you can navigate to the folder where ...
by ascheevel
Wed Nov 06, 2019 5:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not working
Replies: 6
Views: 746

Re: ExecuteProcess not working

Did the execution of SampleExport when called by your 1st TI generate a separate log file of the errors it encountered?