TM1 Forum

... Not Working Rule and Feeders : Skipcheck; ['Cases with TurnAround' ] =N: IF( ['TurnAround Time' ] > 0,1,0); ['Average TurnAround Time' ] =C:DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Dispute Person Responsible, !Dispute Processor, !...

You may have confused yourself here. If you are deriving Average Turnaround time based on Cases with Turnaround Time, this (Cases with Turnaround Time) needs to be on the left I.e. feed from the dependent variable into the one being calculated.
HTH

... 4 . Restarted the Server. However,please know, here i had not changed any value in the cubes( i think this is the concept of "Dirty cubes" which gtonkin was referring to, though i am unsure of that). ... Same as what Lotsaram was saying, you just need to change a cell in the cubes tha...

... I do not even know how to use a hex editor to find the references to the dimension element i want. I surely get that it is a painful job but i would certainly like to get an idea of that. Can Pspad be used for this purpose? You need a proper hex editor, not a text editor, I use Free Hex Editor ...

... These aren't text files so you'll need a hex editor in order to find the references to the dimension element you want. I've never tried this before and I highly doubt it will work but give it a try. Just make sure you do it on backup copies of everything... I have often used the Hex Editor meth...

"worksheet scoped named ranges" relate to named ranges that are valid only on the sheet you define them. For example, If you have a workbook with multiple sheets and each of them had a Business Date cell for example, you could reference that cell using the cell reference e.g. $B$6 or alter...

I would recommend using worksheet scoped named ranges for the process and parameters references. This way, column and rows changes do not affect the Action button. I have also found that between office versions, the Action Button properties seem to change/break, especially the server reference - dou...

Steve Rowe wrote: ↑Wed Dec 06, 2017 10:24 am ...Personally I rarely use them since they behave like strings and I can't write rules versus them...

Thanks Steve, agree on the strings and the usage of another cube as you can secure better as well as use picklists to populate the text "attribute".

Thanks for the response and info Lotsa - will be using option 3 for the foreseeable future as many clients are still on 10.2.2 FP4.

Hi TM123, it does indeed give me the results-too long looking at a problem from one angle. Thanks for the assistance!
FYI - my initial MDX seems to work fine on PAX 2.0.1 - something must have been fixed.

Still curious though about the answers to some of the other questions posed in my initial post.

I am trying to find a better way to filter on a Numeric Attribute (contains 0/1) where the name of the Attribute also happens to be the name of one of the Members. Using the standard syntax to filter on an attribute returns the context error as the MDX is ambiguous. Using the following code does not...

Will refer you to the search function as this has been covered many times over the years - your basic problem is that you are creating fragments by unwinding from the top down-you need to work backwards through the dimension/hierarchy in most cases. Edit: Could you not use MDX to create a subset wit...

I have previously added attributes to the dimension used in column B and read these in to column A to drive the formatting-depends on your needs but may work. You could obviously create composite values and format accordingly.

Try something like this: If the elements exists in multiple hierarchies, only the first is returned.

Should you be suppressing zeroes - you don't appear to be [ViewExtractSkipCalcsSet (sCube, sqView, 0); ]-this could be using too much memory - anything in your tm1server.log or tm1processerrors?

Hi Wim,
Just updated to same release, no issues on my side-I do however load Perspectives via a macro as I switch between 10.2.2 and PAL.
Not sure if that would make any difference in behaviour i.e. Add-in vs Open after launching Excel.

Thanks Wim-still trying to find time to digest the previous processes shared-will add to my backlog!

When you say that a CSV file loads with no problems, but the TXT does not, I get confused, unless you are generating two different files from the ERP.

The file extension should have no impact. What are the field separators in both the CSV and TXT files, for clarification?

Why not use a subset as the basis for your unwinding with only the elements you want to unwind otherwise use ELISANC to check if an element is part of the rollups to skip?

Can also concur with the above-just updated to Build 1709 (8528.2147) and the pre-halloween gremlins have gone, for now!