TM1 Forum

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

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

I've set up a picklist as a workaround to provide a dynamic dropdown customer list within a Revenue Planning spreadsheet It's working great except for one major issue... As soon as I protect the worksheet, I lose the dropdown functionality on the cells that have the Picklist DBRW formulas in them Th...

Dhekta, As a Subject Matter Expert in both products having been a TM1 consultant for the past 17 years and an OutlookSoft/SAP consultant/employee for 4 years inbetween I figured I might as well jump into the mix here... Certainly many of the comments that have been made to your post are valid but th...

Bravo Martin! Bravo!!!! It amazes me how many people think they can be a TM1 expert with no experience Granted viswaraju just wants to jump on the band wagon with everyone else but unfortunately for him he's going to be sitting in the dust THIS TAKES YEARS PEOPLE!!!! Unfortunately IBM Cognos has som...

Well Martin, I think it still DOES stand for Table Manager One... I certainly understand what you mean but there was a time prior to Applix (Back in the Sinper days) when .cub files were actually .tab files ;) And TM1 used to be written as TM/1... I guess when version 7 finally came out they could h...

Hi Martin, Sorry it took awhile to respond to your question and you probably already have your answers... Both the MS and NW versions sit on top of Excel From a front-end perspective the products are identical and all administration happens within the front end which happens to be Excel The differen...

Thanks for the additional information... Why don't you try this... I'm assuming you are running TM1 as a service instead of an application server Set up a test environment exactly like your live environment (except for the server name of course if its on the same box :) ) except run it as an applica...

How many elements are we talking about here? Certainly you don't care about the C level elements in the Corporate Cube unless the data from the local cubes is coming back into the Corporate Cube So focusing on your local cubes... from your first post it seems like your users will have admin authorit...

Maybe this is just too simple a response given what you have posted... Are you sure you don't have a duplicate alias issue? Realize that you can't have duplicate aliases within the same alias attribute Is this for all elements or just specific elements? When using Perspectives, is the same active fo...

Here's some information that may add value to some folks who have tried to install a TM1 Server manually as a service and get error 1067 when trying to start the server While the TM1 operations manual attempts to describe the command line using the TM1sd.exe command it unfortunately left out a key p...

I attended one of the IBM COGNOS Performance events in L.A. on Tuesday... it was an all day event with 8 breakout sessions focusing on either BI or Performance Management Having been a TM1 developer since Perspectives 2.0 I was curious to see what was happening with the little TM1 engine that could ...

Hi Everyone, I'm back from the customer and I wanted to give an update... The customer did upgrade to 9.4 MR1 a few months ago so there doesn't seem to be any issues with compatability But thanks again to everyone for their input... it was very helpful The customer has been using TM1 for almost 10 y...

Thanks guys for your prompt replies... It is much appreciated and I will use this information on Monday when I spend the day in Phoenix :D David, now that I don't have a ball and chain around me I will be heading to the UK sometime within the next few months I typically go in early October due to ch...

Hi Everyone, It's been about 4 years since I've posted a TM1 question so apologies in advance for asking a question that everybody may already know besides me :roll: I've been living on the dark side the past 4 years working with OutlookSoft that sadly was eaten up by SAP a couple of years ago Anyho...