TM1 Forum

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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