TM1 Forum

Hi Matt, Having two cubes are not my choice and it was done by consultant and again, this is the nature of business logic, Which probably you might not have such experience before. The rule and feeders that I posted, YES, it is working perfectly for N level in Cube A to N level in Cube B. But, it do...

Hi Matt, The purpose of having two cubes that having simillar structure is due to the nature of business logic. The cube with the flat structure of COA (Cube B) is to accommodate for consolidation reporting, and this will have actual figures that loaded from the other system. While Cube A, is for th...

Hi all, I have a problem to feed the data from one cube to another cube which have similar structure but different dimension name. The following is the example:- Cube A Dimension Year Dimension Period Dimension Dept Dimension COA Dimension Measures Cube B Dimension Year Dimension Period Dimension De...

Hi, I have a cube called cube A that is heavily loaded with rule and feeder. When I load the data (Forecast1) from *.csv via TI to the cube, the memory will keep increasing. Normally, the loading will took bout half an hour to finish. If I load the same set of data to another version called Forecast...

Hi,
I have used round and roundp. It may resolved this issue but it also cause another issue. If the value is in negative, for eg. -101.5, the system will give -101 instead of -102. So, for this issue, do you have any solution for it?

Thanks.

Hi, I have encountered some rounding issue at consolidation level. Fyi, I have a cube, let say cube A, the amount value that store in this cube are two decimal places (#,##0.00). In Cube B, the format of amount value is "#,##0". When I put the data from cube A to cube B, the amount value w...

I've tested on different version of IE. It seems like it is working on IE 6 but not in IE 7. Fyi, I've done the followings in IE7: - 1. Tools --> Internet Options --> Security --> Internet zone --> Custom Level --> File Download --> Enable 2. Tools --> Internet Options --> Security --> Local Intrane...

Have tried to change the Internet option's setting. The problem still persists.

Hi,
When I tried to export the websheet to PDF, the pop up screen prompt me choose the dimension. After select the dimension and click OK button, no file being export. Excel also having the same issue

Do you have any solution on it?

Thanks.

It applied to all my excel file. And, I've reboot the PC for few times and the problem still exist.

Hi all, I've encountered the following error when I login to my TM1 web: - Error occurred while converting the MS Excel workbook into XML format: Object reference not set to an insance of an object.::Internal Error:The file could not be opened. I have tried to change the setting in Component Service...

Hi Paul,
Instead of putting zero, i put " " and it works. Thanks.

Hi, I have used the validation list in the input template. It works fine when select the data from the list and the value will be saved in TM1. However, when we choose a blank value from the list, the formula (DBRW...) is gone. How to deselect a value from the list without loosing the formula? Thank...

Hi Paul,
If with zero weight, what does it means?

Cheers,
Nicole

David Usherwood wrote:You have probably not changed the tm1s.cfg file to assign a different port. TM1 services on the same box need different ports.

Hi David,
Thanks for your help.

are both tm1 server really started, check tm1server.log if the server did really start? post your tm1s.cfg here post your tm1p.ini here servernames, and so on i think the tm1server isn't really started or you registered it to a wrong adminsrv or your ssl cert is wrong or .. Hi Martin, You are geniu...

The tm1s.cfg in those two databases are having different port number and data directory.

How do I know whether i register to wrong admin server?

Hi, Currently, my server has one TM1 server service (let's call A). Then, I created another TM1 server service - called B using command line. I able to start the service. However, when I went to the TM1 perspective - Server explorer, I only can find "TM1 server A" but not "TM1 server ...

Hi Martin, 25 is under 'All Business Units' but my 'No business Unit' is a separate element. Fyi, my figures was park in both 25 and 'No Business Unit'. If using 'All Business Units', my figure in 'No Business Unit' would not be picked up by the system. Do you have any others workaround? Thanks in a...

Hi, Cube1: Staff HeadCount Data: Year Month Scenario Account Cost Centre Business Unit Measures - Headcount 2010 Full Year QF2 No Account 40 No Business Unit 91 2010 Full Year QF2 No Account 40 25 2 Feeders: ['Full Year','No Account','Headcount']=> DB('General Ledger', !Year, 'Full Year', !Scenario,...