TM1 Forum

Hi, you are right, it is slow because of your LDAPSearchBase parameter. But not because of the syntaxe, if your LDAP link is based on the root, every time a user wants to connect the research of login will browse the whole enterprise directory. It is usual to make a LDAP link based on a node restric...

all string value in N element I assume you mean that string value are stored at leaf level? Because N type is for numeric value. The only reason I can see is that your string values are calculated, in which case you will have to set ViewExtractSkipRuleValuesSet at 0. A good way to debug your proces...

You should lookt at NUMBR function. That must be enough to solve your issue.

I am not sure to know what you want but if it is to let users choosing to use or not wildcard search, the only solution I have in mind is to add an extra indicator and some basic condition in your filter. {FILTER( { TM1FILTERBYLEVEL( {TM1SUBSETALL( [Time Monthly] )}, 0 ) } , [System Information].([S...

Hi EP_explorer, Function Filter with "*" doesn't work - return empty selection Apparently it is trying to find string "*" but not any elements as in FilterbyPattern Function "FilterbyPattern" doesn't work for cube or alias values indeed. As I said in some posts before, ...

I am not drunk, I am seek but anyway. Of course I know rules and process are different engine but developped for same product. So maybe the remark I pointed on TI doc can be true on rules. Just a supposition but I suppose rules follow the same logic and each rule are executed as one instruction. Now...

By chance I just found this documentation for CellGetN function which let me think that any TM1 instruction is executed in one block until there is a semicolon. http://pic.dhe.ibm.com/infocenter/ctm1/v9r5m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.tm1_ref.9.5.2.doc%2Ftm1_ref_id14485tifun_cellgetn.ht...

I am very surprised if it works. Maybe I am wrong but in my comprehension [cdwYear].[Fiscal Year] and [cdwMonth].[PriorYearComponent] will always refer to first element of "cdwYear" and "cdwMonth" dimensions (index 0) not to the assiociated elements in your view / active form. Di...

Hi conray, unfortunatly it is impossible to reference a set of an antoher dimension in a (TM1) MDX subset. You can compare different element with static reference but it won't help you for any view. If you won't some asynchronous reports I heard it is possible to make MDX views in Perpectives (but I...

Hi martin,

this is due to some windows update:
http://www-01.ibm.com/support/docview.w ... wg21608271

I didn't realize that concept indeed.
There is still a way to replace the variable by a cube value (and why not add a picklist on it).
I don't know if that would provide the desire need.

I don't know what is your definition of wildcard but anyway, the issue is not about subset editor but syntax. A simple FILTER can not do a caracters research (let's call it like that to avoid any confusion) and a FILTERBYPATERN don't work on attribute. As you said replacing the variable '| Brand_Nam...

Well first I must tell you I really thinks it is not a good idea to make it with rules because of the complexity of doing it, maintain it, the time and RAM that can consume depending the size of data... Did your client really need to get their rolling instantaneously? If not it is really not a big d...

And it's never going to work because the wildcard concept does not exist in MDX. Actually, it does. You just need to had what we can call, an hidden MDX function. {FILTER( {TM1SUBSETALL( [SSD MPN] )}, INSTR( [SSD MPN].[Brand] , "'| Brand_Name |'" ) > 0 ) } http://pic.dhe.ibm.com/infocente...

Amit,

do you want to make it with a rule or with a process?

Rules would be not an easy task, beacause you will have to go through 20 quarters (or more).

With a process, you can build an MDX subset with filter on cube values and Head function that will give you what you want.

Hi, to get an order with rule I see no other solution then to hardcode all amount elements: ('Indics' is the number of amount dimension). ['Rank']=N: IF( ['B'] = 0 , 0 , 1 + IF( ['B','1'] > ['B'] % !Indics @= '1' , 0 , 1 ) + IF( ['B','2'] > ['B'] % !Indics @= '2' , 0 , 1 ) + IF( ['B','3'] > ['B'] % ...

Hi, I never count the number of chars that a rule can contain but it happens to me only with huge rule. You can fix it if you seperate your rule in several rules. You must probably have IF statements that can use to divide you rule. I never used the code generation so I can't respond to your second ...

If your result change, you obviously have some rules in your reporting cube that make consolidation cells of 'Linked OB Variations' and 'Linked OD Variations' different then a normal consoldation of leaf elements.
You probably should look at it.

I guess you your rule should be on leaf element only [Rpt_Earnings_m:’NB Profit before Comm and Expenses' ] = N: Otherwise "NB Profit before Comm and Expenses" stay as a calculation while "NB Profit" is still a consolidation. The problem with consolidation calculation is that you...

Hi holger,

this should work:

{ FILTER(
{TM1SUBSETALL( [MyDim] )},
[MyDim].CurrentMember.Level.ordinal = 0
) }

level.ordinal refer to generation starting by 0.