TM1 Forum

SELECT
NON EMPTY {[DimCP_Population].[Dr Key].[Dr Key]}
ON rows,
{
[Measures].[PatientCnt] ,[Measures].[TotalPatientCnt]
,[Measures].[PrevalencePercent]

}
ON columns
FROM [StrategyCompanionDWCube]

Hi,
Good to know. Yes, I suspect that you can't use double quotes to escape double quotes in json string. I didn't test but reading from google, you could try to use chr(34) to replace it.
e.g,
String = "This is the Test only." & chr(34) & "double ok" & chr(34) & "."

turn off all your proxy settings in IE

Hi Gurus! Struggling a bit to get the PAX REST API to work. Below is the syntax for the GET request, but I can't find any references (in the documentation, or on the web) to JSONObjectWrapper or JSONParser . Where can I find these, do you know? Public Function oDataGet(path As String) As JSONObject...

Good to know this new VBA functions exist. I am interested in testing this later.

Thanks, haven't used excel table a lot in TM1 web but often use OFFSET function to make dynamic name ranges.

if you can give example in Excel with snapshot, it would be good. Thanks.

Yes, you are right. My query is not right. Anyway, learnt how to use TM1TupleSize functon.

This returns ALL the ancestors of 'e': FILTER( EXCEPT(TM1SUBSETALL([test_ANC]), TM1FILTERBYLEVEL(TM1SUBSETALL([test_ANC]), 0)), TM1TupleSize(INTERSECT({[test_ANC].[e]}, DESCENDANTS({[test_ANC].currentmember})).item(0)) > 0) Thanks, PavoGo. Learnt a lot from your MDX. Follow your thought, I think we...

It is probably worthwhile to reinstall the ODBC driver. See the link,
https://community.microstrategy.com/s/a ... uage=en_US

Looks like Ascendants only returns all parents in the first rollup?1.PNG2.PNG Yes seems to be the case. I just checked with Ancestors function and seems to be the same restriction. Thanks for confirming. I am thinking if we can get same MDX function as what this "rollup" button does, it would be go...

Looks like Ascendants only returns all parents in the first rollup?

Use loop to get it

PavoGa wrote: ↑

Tue Feb 05, 2019 1:32 pm

This will get you the one level down including the target:

Code: Select all

TM1DRILLDOWNMEMBER( {[test2].[c]}, ALL)

will return c and d only.

Thanks

Hi, all I am just wondering if there is any hidden or undocumented function to enable Auto Recalculate for a Cube Viewer? So that when a user open a default view with that enabled already. Similar to other functions, like ViewRowSuppressZeroesSet, ViewRowDimensionSet etc. The reason is that all our ...

2. I change the status in the dimension editor to let the first [c] in [ba] is expanded and the second [c] is collapsed for show all button.

I think I found the root cause of this different behavior. Forget about the ampersand in the parent. It is just collapsed/expanded status of [c] in the dimension that impacts the different behavior of TM1FILTERBYPATTERN function. In multiple rollups for [c] in the dimension, TM1FILTERBYPATTERN funct...

The TM1FILTERBYPATTERN function here gives me the right result after adding asterisk in it but still not give me right result after combining with TM1DRILLDOWNMEMBER funtion. 33.PNG Literally, the following two are the same things, { [test2].[c] } But this gives me the right result all the time. {TM...

Thanks. OK, my original purpose is to use TM1DRILLDOWNMEMBER to get just one level down from that parent, which is this one (add another child for d). See below, And the whole structure is like this,

Hi, after testing around, I think I can replicate the issue. Very simple, as long as the parent exists in multiple rollups and one of grandparent has "&" in between , then it won't show the children of the parent. See the snapshot, Dim structure h1.PNG After MDX h2.PNG No difference for using TM1DRI...