TM1 Forum

cheers Steve. Not sure if this deals with the issue I mentioned, where in order to filter the data as required I have to add in the AND statement but then again my issue isn't the one being dealt with! I think it might be related in some way though. I also use TI to create subsets, the mdx and other...

Yeah, I understood the problem.

As I said my workaround is to plug in an AND statement to specifically exclude zeroes, but it does make you lose a bit of confidence in the mdx.

Hi, I feel like I have seen similar behaviour before when looking up cube values, and my usual workaround is to add an AND statement into the mdx to specifically exclude 0 values, so for example, your mdx would become: {FILTER ( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Division] ) }, 0) }, [08.01.00._Logi...

Hi, As Ellessar has said twice already, what you are trying to do will NOT work if both dimensions are dragged outside the cube view . I posted about this issue here, please read the whole thread: https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/view...

George, another function pulled from your magic hat! Thanks

Hi, Two questions: Is the incorrect order being shown in the image the order of the dimensions in the cube? When you open the active form in TM1Web is the order correct? If the answer to the above 2 questions is Yes this is the bug I think Wim was referring to. My understanding is that this had been...

Wim - I always thought you deserved that title after you figured this out:

viewtopic.php?t=13317

Hi lotsaram, good point about the .Properties, I think that this is the only notation that will be acceptable in the next gen version of planning analytics, so mdx something like this: {FILTER({TM1FILTERBYLEVEL( TM1SubsetToSet([Employee], "Dyna_Existing"),0)}, INSTR([Employee].currentmembe...

Hi Wim,

Because the percentages, at whatever level in the dimensions, need to be calculated in real time ?

Rates in my experience are pretty static, but maybe I need to get out more!

regards,

Mark

Hi, If the advise above does not work: I wonder if you are running into the same issue I had here: https://www.tm1forum.com/viewtopic.php?t=15087 This is an issue with FilterByPattern picking up an alias, which I presume is what Hargrove,Chr is? This was an issue with PAX, so never tested with a TI....

Am I the only one slightly gobsmacked by this?

Anyway George, we will start calling you Sherlock.

regards,

Mark

Hi,

I am struggling to see how a TI process wouldn't be more logical than a unfed rule in the case of rates?

regards,

Mark

Cheers George.

I even asked IBM about this, re this forum discussion:

viewtopic.php?t=14986

It is even undocumented to them!

Good work for joining the dots

Hi George,

The Member_Weight does work, how long has that been around?

I obviously need to pay more attention

regards,

Mark

Talk about dogged persistence, an example to us all! I was then wondering if Element_Weight would return anything but doesn't! I did get Element_Index to work, so for example, Filter( TM1SubsetAll( [Revenue_Msr] ), [Revenue_Msr].CurrentMember.Properties("ELEMENT_INDEX")>"2") rega...

Hi, I don’t think you can set this in a TI or the API, which is a bit of an oversight (unless I missed something). If you look in the actual .vue file then you should see the line 376,0. This, I think, indicates that the auto reclac is off. To switch it on change to 376,1. So maybe some sort of powe...

Hi Keith, The last one can be knitted together as follows: {HIERARCHIZE(GENERATE(FILTER({TM1SUBSETALL ( [Year historic data] ) }, ([Year historic data].[Period Number])> 84),{Ancestors([Year historic data].CurrentMember,1),Ancestors([Year historic data].CurrentMember,0)}))} You need the Ancestors in...

Hi all, update from IBM on the issue with only Admin being able to view specific error messages in PAW via ItemReject: Please note that Development has reviewed the issue and confirmed that non-admin users are not expected to view the complete error message due to a limitation on the TM1 Server side...

Well done Italy, just about deserved it. Though Jorginho should have been sent off!

Roll the World Cup, if you cant stand the heat stay out of the kitchen!

Spain are like a very very very attractive but impotent man. I think if England do reach the final I would prefer Italy, I think we can beat Italy but if we had played Spain we would probably have won but looked very much second best! "Good friend of mine here is English and we, good naturedly,...