TM1 Forum

If you're trying to do this soley in the cube viewer, then the answer is you can't. You'd have to get admin rights and do some development to program in the functionality you need, as suggested above. Your other option would be to load the job start dates in as attributes to the job, seeing as they...

The screenshots are useful and demonstrate that there is no obvious error in your formulas. However, did you try restarting your Excel session or doing the full workbook recalculation, as suggested? I'm sorry I missed pointing this out, but yes I did try your suggestions of restarting Excel as well...

COA2.JPG Cell B12 has the formula, =DBRA("tm1 server - apex:Nexus COA",$A12,"Account Name"), where $A12 is '1000. It returns the attribute, Cash in Bank, which is the Account Name (Alias) for element 1000. Here's a screenshot of the attributes editor for Nexus COA. COA.jpg It lo...

Here is the formula I added: =DBRA("tm1 server - apex:Nexus COA",$A12,"Account Name")

When I slice a cube into an Excel worksheet and leave it the way it is, it works fine. When I add some new formula, it gives me a circular reference error. So I delete the formula and hit recalculate (even though I know the formula couldn't have made that error), but the circular reference error sta...

If you're trying to do this soley in the cube viewer, then the answer is you can't. You'd have to get admin rights and do some development to program in the functionality you need, as suggested above. Your other option would be to load the job start dates in as attributes to the job, seeing as they...

How do I make the status and start date carry over to the consolidated level? Lazarus gave you the answer. Is there a reason you've chosen to ignore it? Actually, I did try Lazarus' answer but it didn't work for me. I thought this was because the reference guide stated this to be a worksheet functi...

Alan Kirk, thank you for pointing me to the reference guide :D I looked at ELLEV and ELCOMP but I don't think this applies to my problem as I am looking at the this from a cube viewer. Allow me to be more specific this time. Cube New Sales, contains 3 dimensions, Jobs, Sales, Month. Jobs dimension c...

You need something like: ['Start Date'] = IF( ELLEV('Month', !Month) <> 0), DB('YourCube', ... , ELCOMP('Month', !Month, 1), ...), CONTINUE ); I haven't tested this, and just wrote it off the top of my head, but it should give you the general idea of the approach. However, date strings are not the ...

Hi, I have a cube that have 4 dimensions: Year, Month, Jobs, Jobsinfo. Jobsinfo has a start date (string). How do I make this string date appear at consolidated level? When I change the month to Q1, all the jobs are listed, but with a blank start date. Any ideas? In order to show a C-level string e...

Hi,

I have a cube that have 4 dimensions: Year, Month, Jobs, Jobsinfo. Jobsinfo has a start date (string). How do I make this string date appear at consolidated level? When I change the month to Q1, all the jobs are listed, but with a blank start date.

Any ideas?