TM1 Forum

... 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!

If you do install PAW, you would need to buy licenses on a 1 to 1 ratio for existing users.
Once upgraded, you cannot downgrade: http://www.ibm.com/support/docview.wss? ... SS9RXT-_-E

As soon as I save the file, seems to lose the char(150) and substitutes with a regular hyphen-cannot really do much more. Hopefully they will rename and you can move forward. I have had similar filenames in the past for Unix environments but managed to work with them by simply surrounding names in d...

Having a problem creating a file with the char(150) in the name-tried Excel VBA, File explorer etc. and it keeps replacing with a normal dash.
Could you upload a sample file, without the data of course.