Search found 2977 matches

by lotsaram
Tue Aug 14, 2018 4:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTRow with MDX Expression that Returns zero elements
Replies: 8
Views: 383

Re: TM1RPTRow with MDX Expression that Returns zero elements

If Excel is crashing if the set is null then you could quite easily work around this by doing a Union with a dummy employee (e.g. +{[employee].[no employee]} ) at the end of your existing MDX. If you don’t have a dummy element in the dimension you could create it. You could even then apply special f...
by lotsaram
Sun Aug 12, 2018 8:24 pm
Forum: Bugs
Topic: Can't convert DBRW to DBSW
Replies: 4
Views: 708

Re: Can't convert DBRW to DBSW

I cannot reproduce this in Excel 2016 (Office 365, 32 bits) and PA 2.0.5 on my laptop with Windows 10. Yes with Excel 2016 / Office365 it is working for me also. The issue occurs with Excel 2010 (which is still used by a few customers, mainly the larger ones). But given Excel 2010 is on limited sup...
by lotsaram
Thu Aug 09, 2018 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 28
Views: 1306

Re: Planning Analytics using twice the memory of 10.1

This goes back to the point I raised earlier regarding attribute based alternate hierarchies. Performance would be hit if the dimension had run in memory before the alt hierarchy, if it was already it would be an advantage. You could also argue it would have initial performance updates after restar...
by lotsaram
Wed Aug 08, 2018 12:58 pm
Forum: Bugs
Topic: Can't convert DBRW to DBSW
Replies: 4
Views: 708

Can't convert DBRW to DBSW

I just came across a new bug in perspectives which I think is new to PA. I see the below describes behaviour using Excel 2010 but it is the normal behaviour using Office365 latest version of Excel. If a cell already contains a DBRW formula then if you change the formula to a DBSW or DBS then on ente...
by lotsaram
Wed Aug 08, 2018 6:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading to Database; ideas
Replies: 5
Views: 154

Re: Loading to Database; ideas

if all the attribute elements for a project loaded in a one go, I will have to make so many number of DB calls. Any ideas? Please let me know if there are questions. If the data source is a view then TI sees for data processing it as if all dimensions are nested on rows and processing of views is a...
by lotsaram
Thu Aug 02, 2018 5:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 28
Views: 1306

Re: Planning Analytics using twice the memory of 10.1

Unfortunately this does not seems to be the cause of the problem, or if it is then it is not confined to time dimensions. You made me think there Paul. I originally thought Lotsa only gave a time dimension as an example. I went back and that seems to be the case. He does not specifically say that i...
by lotsaram
Thu Aug 02, 2018 12:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Log clients uses in TM1 web
Replies: 6
Views: 328

Re: Log clients uses in TM1 web

Does any1 know if its possible to add log of what websheets/views clients are using in TM1web. Yes it is possible with a commercial product https://code.cubewise.com/pulse-features/#tm1web To the best of my knowledge the feature to track TM1 Web usage to user/report level isn't available in any oth...
by lotsaram
Tue Jul 31, 2018 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to find data Type of Cell in TM1 MDX
Replies: 1
Views: 132

Re: How to find data Type of Cell in TM1 MDX

How we can identify the data type ( String / Double ) of the specific cell from the Cells. We build our application using C++ and OData Client library. The cell type in TM1 cubes is determined by the element type of the last dimension in the cube (typically the "measure" dimension). If the element ...
by lotsaram
Mon Jul 30, 2018 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 28
Views: 1306

Re: Planning Analytics using twice the memory of 10.1

I am concerned that some of the Time dimensions include Cumulative to Date calculations which are by their nature recursive, eg 2017 Jan CTD is Starting Balance + 2017 Jan. Then 2017 Feb CTD is 2017 Jan CTD + 2017 Feb. By the time you get to 2020 Dec CTD the size of the MUN that it is going to gene...
by lotsaram
Mon Jul 30, 2018 4:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 28
Views: 1306

Re: Planning Analytics using twice the memory of 10.1

I don't believe that non-leaf elements in the new, named hierarchies need to be unique across all hierarchies. No. Leaves obviously must be unique as the Leaves hierarchy is shared and pools leaf elements from all hierarchies. But C elements don't need to have unique names and you can explicitly ha...
by lotsaram
Fri Jul 27, 2018 6:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax & Perspectives => Active Forms not working
Replies: 4
Views: 720

Re: Pax & Perspectives => Active Forms not working

Thanks for you reply. For now I don't want to launch perspectives, so opening Excel (which has PA) is good. I don't have any action buttons in my active forms. They just return #VALUE. Slicer reports open fine. ... PAX isn’t monolithic but is composed of discrete components. It sounds like the sub ...
by lotsaram
Fri Jul 27, 2018 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to achieve the first login to TM1web to modify the personal password?
Replies: 13
Views: 898

Re: How to achieve the first login to TM1web to modify the personal password?

I just tried a Spinbutton in Excel, first Forms control, then Active X object. Neither of them shows up in TM1 Web. Do you have better experiences ? I use Excel 2016 (Office 365) with PA 2.0.5 I'm not doing anything in TM1web lately. All UI is custom html apps using Rest API. I'm only repeating wha...
by lotsaram
Fri Jul 27, 2018 9:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 28
Views: 1306

Re: Planning Analytics using twice the memory of 10.1

Hi, Just posting to confirm that I noted the same thing with a model after moving it to a new PA 2.0.5 environment. I haven't had time to investigate why. But I suspected it was related to this: http://www-01.ibm.com/support/docview.wss?uid=swg22008561 The change to .cub data storage format is for ...
by lotsaram
Thu Jul 26, 2018 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to achieve the first login to TM1web to modify the personal password?
Replies: 13
Views: 898

Re: How to achieve the first login to TM1web to modify the personal password?

how do you mask the password? I'm thinking about the same solution discussed here. When i made tests i didn't find the perfect font to mask the password. The best way in Excel is just to set cell formatting to mask the text e.g. something like ;;;•••••••• or ;;;*• However, this isn't supported by T...
by lotsaram
Mon Jul 23, 2018 4:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to achieve the first login to TM1web to modify the personal password?
Replies: 13
Views: 898

Re: How to achieve the first login to TM1web to modify the personal password?

I have also done something similar to what Declan has described. TM1 using the default TM1 security mode only allows you control for password length and days to expiry. But if you set up the Websheet password entry form then you can get a bit fancy with little effort and mask the input field and do ...
by lotsaram
Mon Jul 16, 2018 9:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drop Down Calendar Selection
Replies: 21
Views: 6292

Re: Drop Down Calendar Selection

Hi Elessar, haven’t had a chance to check this but I know I’ve had it working in tm1 websheets - do you mean it doesn’t work in the cube viewer in TM1 web or do you mean websheets? Or both? If so what fp are you on. It had been ages since I last tried it out, having given the date picker a go when ...
by lotsaram
Mon Jul 09, 2018 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 986

Re: Executing Java application through TM1 process

This is a pretty good example why it is always a good idea to explain your use case. For this requirement you don’t need any api only the }ClientProperties cube which you could show a null suppressed active form based on the “active” property. All you need is to set ClientPropertiesSyncInterval in t...
by lotsaram
Mon Jun 25, 2018 8:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 466

Re: Retrieving member name by alias

Thanks again, I check out the syntax for subset. For now, since I'm working in excel, I'm just using excel formula to truncate the leading 8 characters... but not sure if it makes in clunkier/slower. ... You could truncate (e.g use a LEFT or MID formula) but it isn't going to work for all cases. Bu...
by lotsaram
Mon Jun 25, 2018 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetElementInsert
Replies: 13
Views: 403

Re: SubsetElementInsert

If you already have an All N subset, assign that to your view to be zeroed out. Alternatively, create dynamic subset for All N using SubsetCreatebyMDX. You should be able to find quite a few examples with a quick search - don't forget to set the last parameter to avoid an error on an empty subset. ...
by lotsaram
Mon Jun 25, 2018 7:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 466

Re: Retrieving member name by alias

Apart from your question, wouldn’t be 5001 the element and salaries overtime the alias ? Good point, shows my lack of understand TM1 infrastructure. So, based on attached, my alias ID is "5010" and alias description is "Compensation - Salary? Am I looking at this right? And would would be the funct...