TM1 Forum

I'm wondering if there is any existing method / has anyone written and VBA code to basically scan a worksheet/workbook and extract a list of all DBRW's/ DBR's (Maybe other worksheet functions) and the parameters being referenced (If they are formula parameters then the values that the parameters con...

Anyway, a few things to consider: When using ORDER, ASC and BASC are for different cases where BASC breaks down any hierarchies before sorting, ASC sorts within hierarchies. I was thinking that because the MDX was returning an N level set that the rollup would not be referred to but I am wrong. BAS...

burnstripe wrote: ↑Fri Nov 25, 2022 2:22 am Alternative option

Code: Select all

{ ORDER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Month] )}, 0)}, [}ElementAttributes_Month].( [}ElementAttributes_Month].[Seq No] ), BASC)}

This one worked! Why?

I had problems with intermittent blank cube view and blank subset editor in PAX/PAFE which appeared with the single file version. Finally resolved with an upgrade to .81 and we were able to use the new subset editor and cube viewer (Release .79). I don't know what in there may have fixed the issue.

I want to order the N members in my Month dimension by sorting on the 'Seq No' attribute which is a 'N' attribute. { ORDER( { TM1FILTERBYLEVEL( {TM1SUBSETALL( [Month] )} ,0)} , [}ElementAttributes_Month].[}ElementAttributes_Month].CURRENTMEMBER.PROPERTIES("Seq No"), ASC) It works fine EXCE...

Having had a good look at how it works I have now answered my own question, the standard functionality gives me what I need.

So I'm in a different place now and they have not yet upgraded to PA but are in the early stages of planning to move. So I'm back to Perspectives! 1) In terms of converting files from Perspectives to PAW my understanding is that it is only the Action Buttons that get converted - Any comment to the c...

Thanks, this is how I though it worked but I had tried that and I thought initially it had worked but was not working for me later, I cannot see any syntax issues in my rule but maybe there is...... I have tested it again and am getting the same result, nothing returns. I cannot see any explanation...

You can "intersect" multiple hierarchies of the same dimension using this syntax: CellGetN( 'cubeName', 'dim1Elm', 'dim2Elm', ( 'dim3Name:hier1Name:hier1Elm', 'dim3Name:hier2Name:hier2Elm', ... ), dim4Elm, ... ); BTW, it can be all dynamic using variables, you can even "omit" so...

Thanks, this is how I though it worked but I had tried that and I thought initially it had worked but was not working for me later, I cannot see any syntax issues in my rule but maybe there is......

So I have a need to write C level rules which apply across multiple hierarchies of a dimension. Cubewise have this valuable information on using DB and multiple hierarchies (I cannot see an equivalent in IBM documentation?) https://cubewise.com/blog/how-to-reference-intersections-of-hierarchies-in-r...

Steve Rowe wrote: ↑Wed Jun 15, 2022 10:23 am Out of interest what is the source application that is not working for you?

SAP Hana and Oracle (ADW)

This does not sound right - We have noticed massive performance degradation when enabling Unicode on some queries/sources. Posting this to to possibly help in some way but to keep track of developments. Besides ODBCOpenEx you could try SetODBCUnicodeInterface to set the flag in the TI code. Also ha...

Thanks for raising JohnO. Have IBM come back with detail on the required config changes to make this happen? I assume "use Unicode" must be checked on the face of the TI and if opening the ODBC connection manually using ODBCOpen you need to use ODBCOpenEx instead? Cheers, Steve Yes they a...

The Ticket is still ongoing at IBM, so far we discovered that it seems to be the qualification of the used URL. If we use "http://servername" the blank windows error may occur sometimes, but not always. If we use fullqualified "http://servername.domainname" it seems to work fine...

This is an FYI only. I installed 2.0.9.14 (Previously 2.0.9.11) in our dev instance and tried to open an existing ODBC sourced TI but it could not open the connection. "unable to open connection to database" What IBM have come back with is: "Based on the discussion from our dev team -...

It's a pretty simple load TI. There is some necessary conditional logic and we write each value to 2 places in the one cube, in a few cases more than 2. Other than that it's not complex so no obvious gains to be had.

Just wondering if there is any known performance hit when loading from an ODBC source vs text. Having just implemented HANA we are now going through the process of moving from relying on text file loads enabling direct querying from TM1 to BW on HANA (Yes we are moving from the dark ages). I started...

We have the same problem. It came about with the new add-in (ie; SIngle file add-in) which we only recently upgraded to. No issues before that. Our users are not using the add-in, they are only using PAW. So it has only been an issue for me so far. There is a documented issue if you search but it ha...

Really need more information to help with this. What objects are reported as locked? Where are your SYNCHRONIZED statements within the processes (i.e. are they at the very beginning, epilog before finishing)? TI B is executing subprocesses with no control, so is TI B finishing before it's child thr...