Search found 3 matches
- Tue Mar 15, 2011 11:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to consolidate dimension with maximum of children?
- Replies: 27
- Views: 29944
Re: How to consolidate dimension with maximum of children?
Hi abcuser Have you considered using the "Max" formula in a rule? Something like this: ['Quantity'] = C: if(Ellev('Defect',!Defect)>0, Max(DB('Reclamation', !Measure, !Product, !Buyer, Elcomp('Defect',!Defect,1)), DB('Reclamation', !Measure, !Product, !Buyer, Elcomp('Defect',!Defect,2))), ...
- Tue Mar 15, 2011 8:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rule Error
- Replies: 0
- Views: 1811
TM1 Rule Error
A client of mine has been running TM1 Vers. 9.1 SP3 for a few years now. Only recently, when I open any rules file, the following error occurs: “tm1 log config file error, restoring defaults. Root element is missing†When I press OK on the error, the rules file does open though. It doesn’t aff...
- Tue Dec 22, 2009 1:48 pm
- Forum: MS Analysis Services
- Topic: Connectivity problem to Analysis Service 9.0 from Excel 2003
- Replies: 0
- Views: 46873
Connectivity problem to Analysis Service 9.0 from Excel 2003
I am trying to create a data source connection in Excel 2003 to Microsoft OLE DB provider for Analysis services 9.0. I manage to connect to the data source (Test connection Succeeded) and I am able to see the available databases and the cubes, but as I select a database and cube and click the finish...