TM1 Forum

You should submit to a whole new thread, this one is from 2012.

I've seen this when there's a circular reference. What do you see when you click Formulas -> Error Checking?

Your best bet imo is to work with your ETL team to get a better source file.

Doesn't Contributor create a bunch of named ranges?

RFE for Python integration on Cloud. In short: any python integration on cloud must include ability to call python script from action button and TI

I've been meaning to share this for a while. The recent post by Palczan spurred me to finally post this. A few times I've needed to find either the next or previous specified weekday (often a Monday) from a given date and save as attribute. Below is useful math for determining next/previous specifie...

While not a wrapped-up function, the below code will calc the ISO week for a given date. There's likely opportunity to improve & refactor this, but I was just having a bit of fun on a Friday. ## temp parameter pDate = '20241231'; pDateFormat = 'yyyyMMdd'; ## parse date parameter nDate = ParseDat...

I second what George said. It seems you haven't fully shared the logic for your "previous date". If you want 2/28 to return 1/31, what should 2/27 return and 2/26, etc? Ignoring all of that, you could use the below code to have 2/28 return 1/31 in your specified output format via rules ass...

TM1SubsetToSet([program], IIF([organization].[parent].[Level] = "Level 0" , "Subset1", "Subset2")) It seems by this code [organization].[parent].[Level] you're trying to first grab the parent attribute of the element from the organization dimension and then the level o...

The process is mainly used for simulation to check the impacts of changing some inputs and verify the final numbers without any committing this data to the cube. ...yes, this is a textbook use case for a sandbox. I've done a bit of testing and the user logging off seems to be a key trigger to unloa...

Are you trying to delete sandboxes during business hours when users potentially have cube views open and reviewing data in a sandbox you're trying to delete? Could you instead try to delete sandboxes during quiet hours or make it part of a startup chore?

IBM ref has a user guide.

lotsaram wrote: ↑Wed Jan 04, 2023 3:34 pm ...use ViewConstruct on the prolog of the TI.

I believe ViewConstruct will be limited by the MaximumViewSize config parameter. If the value isn't big enough for the view you're trying to construct, the TI will abort. It's a dynamic parameter so can be adjusted without restarting the service.

start here

Turned out aliases are used in functions, e.g. ElIsAnc('Dimension 1', 'Alias value', !Dimension 1) rather than in comparisions. and an alias works on the RHS in that situation because it's being used to refer to the element object . An element object is much more than it's string name and can be re...

The issue is how you're referring to the alias and I would say this is expected behavior. You're doing a string comparison, asking if !Dimension1 element-'999'- is equal to a specified string value - '999 - Account' will never evaluate to true as they are not the same. When referencing !<dimension> ...

Thanks PavoGa, for my own MDX I rarely use the ".CurrentMemember.Properties", can you advise when it should be used?

If you're filtering by an attribute string, you don't need to use StrToMember, the below should work assuming no typos on my part. {FILTER( TM1SubsetAll([investmentID]) , ([investmentID].CURRENTMEMBER.PROPERTIES("creation_date") = [SysParameters].([Parameters].[sCurrentYear], [sysParameter...

This might be a good starting point for you writing your own solution.

Are you simply asking the WHY or are you asking if there's a workaround? I'm not aware of a fix. As for the why, my guess is it has to do with Perspectives being an excel add-in and TM1web using open xml file format for excel files since 10.2 and IBM not being bothered to consider that as desired fu...

mrdauduong wrote: ↑Thu Nov 17, 2022 3:48 pm I will wait for the solution in the next update

I think this is the best course of action for you at this time, hopefully the wait isn't too long. Cheers.