Search found 35 matches

by Solanna
Fri Jan 17, 2020 8:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX Formula Issues
Replies: 6
Views: 5641

Re: PAX Formula Issues

Quick update... The IT folks were able to roll back the version of Excel 365... Here is the information for anyone interested: They tried to do a rollback to 2019 December 10 Version 1911 but the issue persisted. So they roll backed to 2018 August 14 Version 1807, which was before the implicit inter...
by Solanna
Thu Jan 16, 2020 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX Formula Issues
Replies: 6
Views: 5641

Re: PAX Formula Issues

My customer is having this same issue with the @ sign in front of the DBRW formula The customer is using Office 365 which is set to auto update... that's another issue but not the critical issue at the moment This update happened last week As mentioned Microsoft has upgraded their formula language t...
by Solanna
Tue Nov 03, 2015 8:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opening XRU file crashes Excel
Replies: 2
Views: 2664

Re: Opening XRU file crashes Excel

Instead of trying to figure out why the XRU is corrupt, why don't you just recreate the file Open the XRU when not logged into TM1 Copy the "live" worksheet into another workbook Save the workbook as an XLSX file Rename the original XRU... for example file.XRUOLD Change the extension on th...
by Solanna
Thu Sep 17, 2015 8:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1 is just for demo
Replies: 13
Views: 7620

Re: Cognos TM1 is just for demo

Alan, Well said on both posts! I find it amusing and just a bit hypocritical that the op calls themselves TM1_Walker I'd be willing to bet they have no idea what TM1 even stands for! ;) Anyhow, thanks for continuing to fight the fight for all of us old timers :) Even with all the additional bloatwar...
by Solanna
Tue Jun 24, 2014 9:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Converting Planning Built-in Function into TM1 Rules
Replies: 7
Views: 5460

Re: Converting Planning Built-in Function into TM1 Rules

The company pays less in the short run, but forgets that in the middle to long run, they pay lots and lots more Well said Wim!!!! It amazes me how organizations will choose the less experienced and cheaper resource in order to assumedly save a few bucks In the end they spend much more time and mone...
by Solanna
Mon Nov 18, 2013 8:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with TM1 Dimensions
Replies: 12
Views: 8120

Re: Problem with TM1 Dimensions

Wim, I get you but I don't buy into it... never have Granted, if you are going to repeat dimension names for multiple cubes (which again I typically don't buy into) then I guess your only solution would be to preface it with some abbreviation I would still not use the underscore and I would probably...
by Solanna
Sat Nov 16, 2013 10:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with TM1 Dimensions
Replies: 12
Views: 8120

Re: Problem with TM1 Dimensions

Stephen, I've also been brought in recently to several opportunities that have poorly developed TM1 systems I guess the upside is that we can at least rescue the ones that reach out :) Unfortunately there seems to be so many bad ones out there :cry: I'm making an assumption here but it seems like al...
by Solanna
Wed Aug 07, 2013 6:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: many to many relationship
Replies: 4
Views: 4530

Re: many to many relationship

Maybe I'm not understanding your problem here, but it seems that you don't have a good understanding of multi-dimensional databases Given your example, I would assume your cube would have the following dimensions: Time - By Month (Jan 2012, Feb 2012, Mar 2012, etc.) Incident Type - Incident A, Incid...
by Solanna
Thu Sep 13, 2012 12:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrating TM1 with Xcelsius
Replies: 2
Views: 2507

Re: Integrating TM1 with Xcelsius

Given that Xcelsius is an SAP/Business Objects product (a bit outdated as well) I highly expect there isn't any connectivity between it and TM1 If memory serves I believe you can use an Excel spreadsheet or a CSV file as your data source so you could certainly either take a snapshot of your TM1 cube...
by Solanna
Thu Aug 30, 2012 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Error in TM1 9.5
Replies: 13
Views: 8341

Re: Excel Error in TM1 9.5

Charan, OK, just trying to eliminate that the issue is not an Excel development issue ;) Have you installed Excel on the TM1 Server? Is the Web Server on the same box as the TM1 Server? I fortunately work in an environment where all TM1 components are installed on the same server including Excel and...
by Solanna
Wed Aug 29, 2012 7:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Error in TM1 9.5
Replies: 13
Views: 8341

Re: Excel Error in TM1 9.5

Charan, Are any of your DRBW formulas within an IF statement? Are you doing any additional calculations with the DBRW formula? For example, dividing by a range name or a cell reference? Are you using conditional formatting within your format area? If so, your Excel report will not work as a TM1Web r...
by Solanna
Wed Mar 21, 2012 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot access XXX.xru message after saving rules
Replies: 9
Views: 6642

Re: Cannot access XXX.xru message after saving rules

Harry, This message has been around since at least 9.4 with Excel 2007 Even though I ignore it, if it wasn't there I would think there was something wrong ;) Just another one of those bugs that IBM Cognos will probably never address since it relates to Perspectives which they don't seem to put much ...
by Solanna
Wed Sep 21, 2011 8:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: restricting access to aliases
Replies: 10
Views: 5577

Re: restricting access to aliases

Alan, Drama, really????? Given that you are the most dramatic of anyone on this forum, I find your comment quite amusing... As an FYI, before I found this post I had actually tried to find other posts out there relating to Dimension Attribute security with little luck However, I did find a post that...
by Solanna
Tue Sep 20, 2011 11:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: restricting access to aliases
Replies: 10
Views: 5577

Re: restricting access to aliases

Is there a way to restrict access to available aliases? I've tried element security on the }ElementAttributes dimension and it didn't work... Thanks, Dan Alan, Unless you are reading a different post or you have the ability to read into Dan's mind... I don't see anything in regards to his original ...
by Solanna
Tue Sep 20, 2011 4:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: restricting access to aliases
Replies: 10
Views: 5577

Re: restricting access to aliases

As a TM1 Developer for almost 2 decades, I tend to make assumptions on how TM1 behaves... Well yesterday I was helping one of my users with a dimension attribute and to my complete surprise the user had write access and was able to update the attribute Besides having a scooby-doo moment or a WTF mom...
by Solanna
Thu Jul 07, 2011 8:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on current cube view
Replies: 3
Views: 2717

Re: Dynamic subset based on current cube view

Have you tried suppressing only on Columns or Rows? You can find this functionality within the Cube Viewer under the Options Menu On many occasions it can solve the issue you have stated A possible workaround would be to use Element Attributes Element Attributes are designed in order to manage one t...
by Solanna
Tue Jun 07, 2011 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Error Message with No Error
Replies: 6
Views: 6055

Re: Action Button Error Message with No Error

Andy, Thanks for the response... As usual my questions are typically to just get validations on issues that other users have also encountered... There are so many of these "fake" error messages within perspectives that I'm starting to think IBM Cognos is secretly breaking the product so th...
by Solanna
Fri Jun 03, 2011 10:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Error Message with No Error
Replies: 6
Views: 6055

Re: Action Button Error Message with No Error

Hi David, Thanks but no thanks :D The Action button works and seems to successfully run the TI process I just want to know what the messages mean while I'm running it ;) And I'm certainly not going backwards to Excel 2003 I finally installed 9.5.2 on our Dev Server today since the users are screamin...
by Solanna
Fri Jun 03, 2011 4:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Error Message with No Error
Replies: 6
Views: 6055

Action Button Error Message with No Error

I have created an Action Button which runs a TI process to copy data from one scenario to another scenario for multiple cubes The TI process runs multiple ExecuteProcess commands and has been working successfully in production for several months The user community would like to take ownership of thi...
by Solanna
Sun Feb 13, 2011 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Active form usage
Replies: 3
Views: 3064

Re: Tm1 Active form usage

Besides the dynamic row capabilities, Active Forms also allow for dynamic formatting as well So besides providing for more function they also provide for a great looking report or input template Keep in mind though that if you plan on going down the Active Form route that they can be a bit finicky a...