Search found 2554 matches

by tomok
Wed Jul 17, 2019 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create temp view and open them by returnviewhandle
Replies: 2
Views: 121

Re: Create temp view and open them by returnviewhandle

I'm pretty sure you can't define a view as temporary when using the drill-thru to a view functionality. The whole point of this functionality is so a user can see the data in the cube at the drill-thru. If you define it as temporary to the process then it wouldn't be available for the user to view.
by tomok
Wed Jul 17, 2019 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 4744

Re: Export Cube data in CSV file, with all Months as columns

If you employ the method in this thread you will have to explicitly define subsets for every dimension in the cube you are using as the data source. Since you have to turn off "Skip Consolidated Values", if you don't specify a subset for a dimension you will get every element in the dimension in you...
by tomok
Mon Jul 08, 2019 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM PA Local 2.0.7: TM1 Web started showing -0
Replies: 2
Views: 339

Re: IBM PA Local 2.0.7: TM1 Web started showing -0

There were changes to TM1Web formatting in this release. More than likely this is the culprit. You may have to play with your formatting on these sheets.

https://www.ibm.com/support/knowledgece ... tting.html
by tomok
Sun Jul 07, 2019 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to configure TM1WEB to access from other network
Replies: 5
Views: 915

Re: How to configure TM1WEB to access from other network

I doubt this has anything to do with TM1. I've never used Azure but I have a good bit of experience with AWS. When you say machinename are you referring to the internal machine name in Azure or the externally facing IP/MachineName? You need to use an address that people outside of the Azure network ...
by tomok
Wed Jul 03, 2019 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: difference between prolog, metadata, data, epilog
Replies: 13
Views: 8896

Re: difference between prolog, metadata, data, epilog

Maybe I missed the bit about when you needed to split up processes! Maybe because there isn't anything in the documentation about splitting up processes and maybe because I've never heard of any such requirement. You can most certainly do dimension builds in one process. There is no technical requi...
by tomok
Wed Jun 26, 2019 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Go to another worksheet Match title elements
Replies: 2
Views: 168

Re: Go to another worksheet Match title elements

The puzzle for me is how does it do this? Is it because match title elements somehow reads the subnms on the source sheet and applies them to the target sheet? edit: I have read the IBM guide on this which I know does say it matches the elements, I was just hoping for some information as to how exa...
by tomok
Mon Jun 24, 2019 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading metdata changes via MDS to TM1
Replies: 3
Views: 257

Re: Loading metdata changes via MDS to TM1

Hi, Our business uses MDS to update three Center dimensions used in TM1. We have several hierarchy center dimension changes that I wanted to find out if there is an automated way to update in MDS rather than manual one at a time like adding base level centers and nodes. Any guidance is appreciated....
by tomok
Fri Jun 21, 2019 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 338

Re: ODBO Process

So I assume you are using a cube view as the data source. Change the view to not use the alias for the dimension(s) in question.
by tomok
Wed Jun 12, 2019 10:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet Refresh Button in WORKSPACE
Replies: 6
Views: 597

Re: Websheet Refresh Button in WORKSPACE

mnasra wrote:
Wed Jun 12, 2019 7:42 pm
Hi Expert,

I have an active Form with a Rebuild Sheet Button.
When I added the websheet in Workspace the Button does not work.
Did you build the Active Form in PAX or Perspectives? If Perspectives, have you run the utility that converts the action button to work in Planning Analytics?
by tomok
Tue Jun 11, 2019 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspective Vs Pax
Replies: 10
Views: 1255

Re: TM1 Perspective Vs Pax

Does anyone know if IBM planning to ditch/not support perspectives in the near future? Your guess is as good as mine but let me point out that Perspectives is based on the legacy API and PAX is based on the REST API/MDX, AKA, the future direction. How long do you think they will continue to support...
by tomok
Tue Jun 04, 2019 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding dimensions in}Securityoverlayglobal cubes manually
Replies: 1
Views: 132

Re: Adding dimensions in}Securityoverlayglobal cubes manually

Is their any way of inserting dimension name in place of 1 's and 0's. That's what the 0's and 1's are for. O means do not include the dimension and 1 means include it. This is based on the dimension order in the cube you are creating the }Security overlay on. You can't include dimensions that are ...
by tomok
Mon Jun 03, 2019 10:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 470

Re: RunTI Issue

Is anyone using this in the IBM Cloud? Care to share any experiences with getting it to work?
by tomok
Mon Jun 03, 2019 10:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics - TM1 - Security
Replies: 5
Views: 208

Re: Planning Analytics - TM1 - Security

How many other groups is the user in? What kind of access do those groups have to the dimension?
by tomok
Fri May 31, 2019 3:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: display Dimension dialog box from TI process
Replies: 3
Views: 192

Re: display Dimension dialog box from TI process

Hello, Q 1) I want to create an action button to invoke a TI that takes an Element name as an argument. Can we create this form with action button from Architect or we need Perspective ? Q 2) Lets say we have a Dimension named Product and one of the element in it is Electronics. Can we display prod...
by tomok
Thu May 30, 2019 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI summary display
Replies: 14
Views: 827

Re: TI summary display

Now i am only unable to get the start time on the time i click the run button. You could always pass the start time as a parameter of the TI process that pulls from a cell in Excel with the NOW function but why bother when you can get the start time in the Prolog of the process like you are current...
by tomok
Tue May 28, 2019 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI summary display
Replies: 14
Views: 827

Re: TI summary display

But Steve In the video link i have provided they have done it i don't know how using RestAPI or VBA or through any other function. I watched the video and they did not present a running progress bar or any other visual timer. What I saw is a cell that showed the running time of a TI process that pr...
by tomok
Tue May 14, 2019 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The TM1Web service parameter was not specified or is not one of the configured locations
Replies: 2
Views: 224

Re: The TM1Web service parameter was not specified or is not one of the configured locations

IBM has very specific and detailed instructions on their web site for where the various files should be placed on your Cognos Analytics and Cognos Gateway (if you have one) servers. Did you follow them to the letter? If you did and it still doesn't work I recommend you contact IBM Support and have t...
by tomok
Thu May 09, 2019 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Uploading a TM1 Application through the REST API
Replies: 3
Views: 1050

Re: Uploading a TM1 Application through the REST API

I'm pretty sure that there aren't any functions in the REST API library for publishing Excel workbooks to the Application tree. I could be wrong. However, you don't have to be an Administrator per se to publish a workbook, you just have to have Admin rights to the spot in the application tree where ...
by tomok
Thu May 09, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access denied to cells for non admin users in TI Logs
Replies: 3
Views: 211

Re: Access denied to cells for non admin users in TI Logs

Can anyone help me out. Thanks in advance.. All I can tell you is if the users can't see and/or change a value in the cube while an admin can then the user does not have adequate security to do so. I have no idea why because I know nothing about your models, security groups, and how the particular ...
by tomok
Tue May 07, 2019 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 485

Re: TI - Add new element in alphabetical order under consolidation

Sheesh this ran a little off topic. But while I'm here ... DimensionSortOrder sets properties for a dimension; the dimension is not actually sorted until it is saved on the server. You don't need a SaveDataAll or for that matter CubeSaveData('}DimensionProperties') What the documentation is saying,...