Search found 2979 matches

by lotsaram
Fri Aug 17, 2018 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to know last cube updated time in TM1
Replies: 5
Views: 559

Re: How to know last cube updated time in TM1

I have a scenario in which there is a cube export TI which executes every 15 min and places the file at the specific location. Now I need to enhance this logic in a way that the export TI should execute only when there is data change in the cube, not every 15 min as the former way is taking unncces...
by lotsaram
Wed Aug 15, 2018 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - Attribute hierarchies, Element Security
Replies: 2
Views: 268

Re: PAW - Attribute hierarchies, Element Security

Yes if you are using HierarchyDestroy and you have element security then if you re-create the hierarchy then the security for the hierarchy will be NONE for all elements, all groups. This is another reason why CreateHierarchyByAttribute is not really suitable for a production system on a chnaging di...
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: 420

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: 722

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: 1344

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: 722

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: 164

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: 1344

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: 331

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: 135

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: 1344

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: 1344

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: 724

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: 904

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: 1344

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: 904

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: 904

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: 6303

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: 990

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...