Search found 632 matches

by gtonkin
Fri Apr 12, 2019 6:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: calculating WTD, YTD and QTD with rules
Replies: 5
Views: 737

Re: calculating WTD, YTD and QTD with rules

I will 3rd that in David's absence. I had a sales performance model at daily level using all sorts of rules to do the same "rollups". Feeding was an absolute nightmare as a sale on 1 Jan had to effectively feed into the rest of the year to ensure that WTD, MTD, YTD were adequately fed. Short of it i...
by gtonkin
Wed Apr 10, 2019 6:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade PAW from 2.0.4 to 2.0.6
Replies: 3
Views: 421

Re: Upgrade PAW from 2.0.4 to 2.0.6

I have something to share on this finally. I had a nice working version 30 and thought I should upgrade to version 39 to take advantage of the bugs fixes and enhancements. Keep in mind that this is on a dev environment and I did not bother with backing up or restoring and of the cruft I had put toge...
by gtonkin
Mon Apr 08, 2019 6:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Subset Disappears?
Replies: 3
Views: 118

Re: TM1 Subset Disappears?

Could be that the window is off the viewable area of the screen.
Try using the Windows key + the arrow keys to bring it back into view - you may need to repeat directions to get it back.
This often happens after you have had another monitor connected.
by gtonkin
Fri Mar 29, 2019 4:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA API Changes for Excel 64 bit?
Replies: 3
Views: 493

Re: VBA API Changes for Excel 64 bit?

Not at my PC right now but seem to remember having to not only add the PtrSafes but needed to change the ‘As Long’ to ‘As LongPtr’

HTH
by gtonkin
Thu Feb 28, 2019 6:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 13
Views: 822

Re: Drill-through to a cube view

I normally copy the ReturnViewHandle below the generated section then go to the data source and set to none.

I generally only need the parameters so that I can build and assign the view in Prolog. No need for Metadata and data. YMMV
by gtonkin
Thu Feb 14, 2019 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Report in TM1web
Replies: 6
Views: 275

Re: Active Report in TM1web

I normally start an active form by identifying what drives the results. In your case, you need to decide which measures drive it i.e. show the row if one-sided is non-zero, show if two-sided is non-zero etc. Based on the screenshot, the activeform will show a row if any of the columns has a non-zero...
by gtonkin
Wed Feb 13, 2019 10:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 24
Views: 2689

Re: PAW not working after network changes

Thanks for the information - unfortunately in my case it did not appear to be something else on port 80 but will definitely add your comments to my ever-growing notes for the next time!
by gtonkin
Sat Feb 09, 2019 5:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 657

Re: MDX StrToMember Error

... StrToMember(" [Site].[ "+[}ElementAttributes_Project].([}ElementAttributes_Project].[Primary Site])+"]") StrToMember as you said wants a string - the reference to Primary Site is still an element/member. Try adding a .name to the end i.e. StrToMember("[b][Site].[[/b]"+[}ElementAttributes_Projec...
by gtonkin
Tue Jan 29, 2019 5:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tools to rename user folder in PA
Replies: 2
Views: 148

Re: Tools to rename user folder in PA

A fairly quick low-tech way may be to use the command prompt and Excel: Open the command prompt, cd to your TM1 data folder then do: DIR *. /b >directories.txt - open the resulting txt file in Excel - remove non-user folders, sort if necessary to aid checking - add a formula in column B to transform...
by gtonkin
Wed Jan 09, 2019 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 14
Views: 964

Re: TM1 Certifications

Also trying to see what is required to remain compliant from a BP point of view found this link to the Sales Foundation Badge for Planning Analytics: http://www.ibm.com/services/weblectures/dlv/partnerworld/PA_Foundations_Badge The other badges (or at least those I can find) look to be here: https:/...
by gtonkin
Wed Jan 02, 2019 7:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives interacts with other VBA code in Personal.xlsb
Replies: 16
Views: 931

Re: TM1 Perspectives interacts with other VBA code in Personal.xlsb

Hi Wim/bgregs, I have had some inexplicable issues in the past when loading the add-in when Excel start, i.e. configured under the Excel Addins, versus opening Excel then opening TM1p.xla to load Perspectives - From you initial post Wim, sounds like you are loadind TM1p.xla later - is that correct? ...
by gtonkin
Fri Dec 21, 2018 7:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Notepad++ 7.6 for TM1 process and Rules
Replies: 17
Views: 1068

Re: Notepad++ 7.6 for TM1 process and Rules

+1 for VIM - I use it too, especially when editing the .pro files directly.
by gtonkin
Mon Dec 17, 2018 5:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get all table names on ODBC connection
Replies: 7
Views: 448

Re: How to get all table names on ODBC connection

I would also use some client tools to connect to the database but if you only have TI then use it.

I use the following:
SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES

Should return the tables then you can use:
SELECT Column_Name FROM INFORMATION_SCHEMA.COLUMNS Where Table_Name='<tablename>'
by gtonkin
Wed Dec 12, 2018 6:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Notepad++ 7.6 for TM1 process and Rules
Replies: 17
Views: 1068

Re: Notepad++ 7.6 for TM1 process and Rules

Rtel wrote:
Tue Dec 11, 2018 4:37 pm
...
1) How do I use/setup Notepad++ 7.6 to Edit and Save TI processes. I am not sure how to set up Notepad++ 7.6 for TM1 10.2.2. Its painful indenting TI with space bars in TM1 native editor.
...
If you are looking to indent in TI, try Ctrl+i
by gtonkin
Fri Nov 16, 2018 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer TM1 }ROLLUP feature
Replies: 2
Views: 284

Re: Cube Viewer TM1 }ROLLUP feature

Unless the elements that they will select are completely random, you could give users a set of dropdowns/picklists then use these in an MDX query to return the desired elements. Another alternative that I used once was to give the user a list area into which they could select elements - N's and C's ...
by gtonkin
Fri Nov 16, 2018 6:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX using OR
Replies: 5
Views: 559

Re: MDX using OR

Maybe another option is to use Subsets - I have a Current Year on my Year dimension and a Current Month on my Month dimension in one model. I have a cube with a 1 or a 0 for sites to indicate if they are active for publication that period. I can then filter for Sites being active during the current ...
by gtonkin
Wed Nov 14, 2018 3:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule driven Consolidation values disappear on suppress Zero
Replies: 5
Views: 510

Re: Rule driven Consolidation values disappear on suppress Zero

'A' is calculated and unfed again - this will not help you.

Adding Total Rate as a child should help otherwise write a feeder from Total Rate to Rate%
by gtonkin
Tue Nov 13, 2018 9:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PMHub Error 404 - PAL 2.0.5
Replies: 1
Views: 400

Re: PMHub Error 404 - PAL 2.0.5

Nudging this one back to the top to see if anyone reading may have insight. Still battling to get PMHUB back but have no idea where to check that it gets started with the rest of PMPSVC, TM1Web and related.
by gtonkin
Fri Nov 09, 2018 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Web View
Replies: 6
Views: 970

Re: Tm1 Web View

I could be misunderstanding the issue as I interpreted "concatenate" in the context of the images as "wrapping".
In theory, the link I posted should help with the wrapping on the text in "Historico"
by gtonkin
Thu Nov 08, 2018 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Web View
Replies: 6
Views: 970

Re: Tm1 Web View

Coming in a bite late but saw this again today and thought I would post to see if you had tried or were aware of it.
Wrapping string values in cube views