TM1 Forum

Hi, We are trying to implement TM1 web for reporting however we are finding that all formatting except number formats are lost from spreadsheets when viewed via TM1 web. We are using 9.4.1, Windows Server 2003 R2 and IE6, the server is running Excel 2007 however client machines are using Excel 2003....

Hi Alan, Thanks for your reply. I was afraid that was going to be the case. And you are right, if TM1 Web is going to be useful for such things as executive/board reportign it's handling of comments has to be improved. It's great that the 250 character limit has been addressed by Excel2007 and 9.4, ...

Hi, We are evaluating the use of TM1 web for board reporting and have come across the issue that carriage returns between paragraphs get lost when rendered to the web page. The carriage returns are captured in the cube (when we paste the text to notepad from the cube all the carriage returns are the...

Thanks Neil and Alan for you suggestions and help. You are right, the code is in the prolog tab., and I should have clarified that the dimension is recreated each day and comprise 12 complete 7 day weeks, with there being a hanging 1st and 13th week when Day 1 is not a Monday. By changing nStop to e...

I am trying to build a rolling 13week Period dimension using TI. I have got the dimension populating with the 91 days (Today to 13weeks in the future). METADATA nCurrDate = DAYNO(TODAY); nCurrWeek = WEEKNUM(TODAY); WHILE(nCounter<nStop); sysDate = DATE(nCurrDate); currMonth = SUBST(sysDate, 4, 2); #...

The company I work for has the licence for the latest version of Dundas charts which it uses for its MS Reporting Services cubes. As I like some of the charting and dashboard objects which it has, I was hoping that I could integrate some of those controls into my TM1 dashboards. I am just not sure h...

Hi,

Has anyone had any experience with integrating Dundas charts with Excel and TM1

Cheers,

Robert

Hi,

Thanks a lot. That works perfectly.

Cheers,

Robert

Just an update. I made the folllowing change which gets rid of the error but makes no difference to what is being retieved. SELECT {([Version].[Actual], [Debt_Measures].[Credit Limit])} ON COLUMNS, NON EMPTY {[IntegraT_Facilities].[Total Australian Facilities].Children} DIMENSION PROPERTIES [Integra...

Hi, Thanks for your help and quick reply. I have tried your suggestion (see below) without any luck. MDX EXPRESSION: SELECT {([Version].[Actual], [Debt_Measures].[Credit Limit])} ON COLUMNS, NON EMPTY {[IntegraT_Facilities].[Total Australian Facilities].Children} ON ROWS DIMENSION PROPERTIES [Integr...

Hi, I am trying to retrieve a specific member property (the attribute Description) rather than the Caption property when generating a report using VBA and MDX. Code: AccountCode = cst.Axes(1).Positions(0).Members(h).Caption Example: AccountCode = 3005 The above returns an account code, however I wan...