Search found 1522 matches

by declanr
Mon Dec 18, 2017 5:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 10.3. - Date Picker?
Replies: 1
Views: 373

Re: TM1 Web 10.3. - Date Picker?

10.3 was the first PA cloud offering. So it’s available in cloud or any on premise PA version.
Simple to set up; it just automatically makes any date formatted numeric cell in TM1 Web a date picker.
by declanr
Wed Dec 13, 2017 6:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 1244

Re: Change in Element Name of a frequently used Dimension

I have never had a problem with swapping the alias in as long as you do it carefully. You start with an element called “sprouts” and give it an alias called “turkey”... for TM1 to allow this in the first place you know that there can’t have been any other elements named either Sprouts or Turkey so t...
by declanr
Sat Dec 09, 2017 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 1326

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

One more option is that the work in excel could be a red herring.
I believe if a user pressed an action button when they don’t have access to run the TI; you don’t see any messages in the log... would be nice to see a “Bob can’t run TI x” but at the moment I don’t believe we get that.
by declanr
Tue Dec 05, 2017 7:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create view consisting of C elements
Replies: 4
Views: 470

Re: Create view consisting of C elements

It’s also worth noting that by default TIs skip consolidated records as normally we don’t want to use them as a source.

On the occasions that you do want to use consolidations, you need to let the TI know by using code as below:

Code: Select all

ViewExtractSkipCalcsSet ( <MyCube>, <MyView>, 0 );
by declanr
Wed Nov 22, 2017 9:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sum on TM1 Cube
Replies: 5
Views: 725

Re: Sum on TM1 Cube

Create a cube (as Paul suggested) with an extra dimension for "client" - this cube can contain all the same other dimensions as the cube in your screenshot and then is simply update by rules that say if the client measure in source cube for "Cliente" is equal to the client element in your dimension ...
by declanr
Mon Oct 30, 2017 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Child Elements are not visible under consolidations
Replies: 14
Views: 1051

Re: Child Elements are not visible under consolidations

What tab did you run the dimensionsortorder on?
by declanr
Tue Oct 17, 2017 5:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW will not retrieve data for parent account not in subset.
Replies: 2
Views: 381

Re: DBRW will not retrieve data for parent account not in subset.

Sounds like you are referencing your active form view in the DBRW. If you reference the active form view for an element that isn’t part of the view (not in the subset) then it can’t pull the resulting value from the cache as it’s not there. Change the referenced view to a hard coded cube name to pro...
by declanr
Sat Oct 07, 2017 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Not Working. Cannot Configure Correctly
Replies: 2
Views: 436

Re: REST API Not Working. Cannot Configure Correctly

For the REST API to work you need HTTPPortNumber specified in your TM1s config file; I can't see it in yours.

For example if you specify a HTTPPortNumber of 1234 in a TM1 server the URL to use would be:
http://MyServer:1234/api/v1/
by declanr
Thu Oct 05, 2017 7:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 4573

Re: PAW installation help

As the good doctor alludes to with his mentioning of the firewall; that is the response I get if I forget to allow the required ports through.
by declanr
Thu Sep 28, 2017 6:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms using multiple cubes
Replies: 5
Views: 617

Re: Active Forms using multiple cubes

Might be wrong but think the OP wants zero suppression in a way that shows an element in a common dimension when there are values in either cube A and/or cube B. If that is the case I would normally depending on a number of factors either: A/ rule values from one cube to the other and then zero supp...
by declanr
Fri Sep 15, 2017 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Not Fed issue
Replies: 6
Views: 752

Re: Not Fed issue

Is your next period attribute populated correctly? Try clicking trace feeders to see if the value is being pushed to the next month and then you should see where it fails.

If you provide your full rules sheet/s it should help people to analyse it for you.
by declanr
Mon Sep 11, 2017 6:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workspace - Selector Widget Slider Timing
Replies: 3
Views: 735

Re: Workspace - Selector Widget Slider Timing

Thanks for the confirmation Steve, for the most part I have found everything in PAW pretty intuitive so I assumed when I couldn't see anything in the obvious places it probably wasn't a possibility. It's not something I'd be likely to use anyway (slider play button) but when I see something that sho...
by declanr
Mon Sep 11, 2017 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTROW Repeat Problem
Replies: 19
Views: 2100

Re: TM1RPTROW Repeat Problem

Just a quick though, do you have a subset called "TOTAL CONTAS ORÇAMENTÁRIAS" - unlikely as I think the MDX syntax you have would error but you reference a subset name in the same way as an element name in MDX so could possibly cause confusion.
by declanr
Sat Sep 09, 2017 5:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workspace - Selector Widget Slider Timing
Replies: 3
Views: 735

Workspace - Selector Widget Slider Timing

Hi All, I have a question that I imagine will either have an extremely simple answer or be something that isn't an option yet. I have a selector widget set as a slider (periods) on a workspace page with all of my other charts etc set to sync with it; when you press the "play" button it loops through...
by declanr
Sat Sep 09, 2017 5:33 pm
Forum: Cognos Planning and BI
Topic: BI Hierarchy Refresh
Replies: 5
Views: 2799

Re: BI Hierarchy Refresh

No worries, if you haven't done it before it can be hard to think of the correct terms to search for in the user guides. A server restart also does the same job and I did a project a little while ago at a company that has a scheduled restart every night just in case anything like that had changed.
by declanr
Thu Sep 07, 2017 6:43 pm
Forum: Cognos Planning and BI
Topic: BI Hierarchy Refresh
Replies: 5
Views: 2799

Re: BI Hierarchy Refresh

Haven't seen it happen specifically like this but just to check, have you performed the mdx hierarchy refresh function in TI?
by declanr
Thu Sep 07, 2017 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use Active Form but found duplicate Hierachy
Replies: 9
Views: 1844

Re: Use Active Form but found duplicate Hierachy

I encounter also to this problem, and also to an TM1RPTROW-Formula, which doesn't resolve the subset in Perspectives, but later in TM1Web it does. My version indeed is 10.2.0 FP3 and my Excel is 2013 (for development clientside) resp. 2010 (on the server). Here the appearence: ActReportNoneOrDuplic...
by declanr
Wed Sep 06, 2017 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter a string cube data in MDX
Replies: 2
Views: 519

Re: Filter a string cube data in MDX

Not entirely true, you can loop through the products dimensions by using the generate MDX statement. So it would be generate on a level 0 product subset then pass that in to your other mdx statement using current member. Not always the most efficient though if the product dimension is large.
by declanr
Fri Sep 01, 2017 6:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule - Mixing And Or in a If Statement
Replies: 4
Views: 902

Re: TM1 Rule - Mixing And Or in a If Statement

I think the high level concept you are trying to get to is just fixed by using brackets but I may not understand your question fully.

Code: Select all

['Measure']=N: If ( ( ['Thing'] = 1 % ['Thing'] = 2 ) & ( ['ymabob'] = x ), do stuff, do other stuff );
by declanr
Mon Aug 28, 2017 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 4573

Re: PAW installation help

Can't imagine many people/anyone will have tried an install on windows 7 home premium to tell you if it actually works but based on the OS I would guess your PC probably doesn't have a great deal of RAM etc but you appear to have selected all default settings for the VM (8gb RAM, 4 cores, 20gb disk ...