TM1 Forum

This might help:

http://www.tm1forum.com/viewtopic.php?f ... ube#p26382

Thanks

This might help.Thanks

http://public.dhe.ibm.com/software/dw/d ... ration.pdf

"Tomok...your comment was very rude and demeaning. I apologize for not providing the right amount of information, but there is a better way to ask for it without being so rude." Hi tkingcka,I think you took it a wrong way of Tomok's comment he just plain honest.Unless we provide complete i...

You would lot better off by going through IBM Help PDF guides than IBM Cognos Tm1 Cookbook,particularly the Turbo integrator guide and Rules guide.Thanks

One more point to check is METADATA. Moving of Metadata could cause this issue too... Means you have your numbers in place and nothing got changed at transaction level but what if your consolidation elements gets moved? Example : If your numbers at product hierarchy got changed at higher level when...

Hi All, I have a Chore that runs several processes that populate dimensions and cubes. At the end of this chore I would like to run a process that sends an email to a user to confirm either that the chore completed ok or it failed. I've worked out how to send an email - but how do I identify when a...

Thanks for scorn,Mate,fyi,I am not a consultant just moved from CognosBI to TM1 support.Appreciate your help.

I am trying to load data from CSV file in to TM1 cube.When i run a process it gives me below error "AA0035","AA003505.....Data source line(75) can't convert field number 6 ,value "DRA10" to a real numer. I have went through previous post of the same error and checked the CSV...

Hi All,Rules guide defines the exclamation mark used in the rules as "The exclamation point character is used as part of the !dimension argument in the rules DB function and should not be used in object names that will be used in rules. DB('MarketExchange',!market,!date)" It is bit vague,w...

Thanks,Alan.The Actual are coming from EDW and loaded in to the cube by Finance guys monthly.

We have a requirement that Forecast will only be loaded when actual of that month is present in the cube otherwise forecast data shouldn't be loaded. I am sure i have went through similar post but couldn't find it when i needed.Any help will be highly appreciated.Thanks

I have finally resolved it,the error was misleading,actually two dimensions had "None" access and i gave them read access.It is working for other user also.Thanks

I have done security set up in Non prod ,when two user are trying to test the security in Cognos report studio one is getting the error Error 501: The MDX query submitted to TM1 server failed during execution" while other user could login successfully.The documentation says it could be due to d...

What is best practices for checking overfeeding and underfeeding?Appreciate your help

Thanks,declanr.The third option "3- They enter the admin host and next time they come to their PC it has reverted automagically to the old host" in our case.

We have upgraded from TM1 9.5.2 to 10.1 .The annoying thing for some end users they have to enter admin server name each time they login to TM1.How could this be avoided so that they wouldn't have to this.

I am not sure whether there is free or trial version available for CognosTM1,but for the Material perspective you can start with TM1 material available at
http://www-01.ibm.com/support/docview.w ... wg27017272 , and of course by going regularly with TM1 forum.Thanks

My client wants new TM1 to be designed along the DWH conformed dimension Model.What i understand is conformed dimension is needed when one dimension table is linked with more than one fact table.How conformed dimension is relevant in TM1,if it is then what is the best practice?Thanks

Hi gurus, I am using report studio 10.1 here I have a date column from a TM1 cube and I am in need to access the member instead of an attribute for a date field and report studio displays the number for the date field from TM1 cube. The number is the number of days from 01-01-1900, eg:- 41306 for J...

Thanks Allan,Isn't it Dimension Worksheets are used by only TM1 veterans and not a common practice by current lot,I agree it is easy to main and scalable.Please Clarify.