Search found 33 matches

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

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 the new work...
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: 1867

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

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

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

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

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

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

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

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

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

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

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

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

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

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 that the use...
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: 1726

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

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

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...
by Solanna
Wed Feb 02, 2011 5:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Picklist access in protected Excel 2007 worksheet
Replies: 8
Views: 3672

Re: Picklist access in protected Excel 2007 worksheet

Lotsaram, Just to clarify the Processing Spreadsheet... I completely agree with your statements but my example was really in regards to development and the quick and dirty way it would zero portions of a cube I certainly wasn't talking about using them in a Production environment And yes, certainly ...
by Solanna
Wed Feb 02, 2011 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Picklist access in protected Excel 2007 worksheet
Replies: 8
Views: 3672

Re: Picklist access in protected Excel 2007 worksheet

Lotsaram, Thank you for running the same tests and validating my findings... To answer a couple of your questions/statements... No, the workbook was not protected Yes, I was aware of the hidden worksheet as well as the range name ;) After coming across this protection issue, I came up with another w...