Search found 74 matches

by rozef
Thu Sep 04, 2014 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LDAP Question
Replies: 1
Views: 632

Re: LDAP Question

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...
by rozef
Fri Jan 17, 2014 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Skip Consolidate or Blank value in String Cube
Replies: 8
Views: 2725

Re: Skip Consolidate or Blank value in String Cube

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...
by rozef
Mon May 06, 2013 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to Fix a Quarter going forward
Replies: 4
Views: 1111

Re: Rule to Fix a Quarter going forward

You should lookt at NUMBR function. That must be enough to solve your issue.
by rozef
Tue Apr 30, 2013 1:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX query for filter
Replies: 24
Views: 6832

Re: MDX query for filter

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...
by rozef
Tue Apr 30, 2013 11:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX query for filter
Replies: 24
Views: 6832

Re: MDX query for filter

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, you have to use INSTR function...
by rozef
Thu Apr 04, 2013 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How does TM1 calculate long formulas?
Replies: 17
Views: 3695

Re: How does TM1 calculate long formulas?

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 rozef
Wed Apr 03, 2013 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How does TM1 calculate long formulas?
Replies: 17
Views: 3695

Re: How does TM1 calculate long formulas?

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...
by rozef
Wed Mar 13, 2013 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX help
Replies: 6
Views: 1078

Re: MDX help

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. Did you try it for oth...
by rozef
Tue Mar 12, 2013 9:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX help
Replies: 6
Views: 1078

Re: MDX help

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...
by rozef
Wed Mar 06, 2013 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code for creating Dyamic Subsets with Process
Replies: 19
Views: 3182

Re: Code for creating Dyamic Subsets with Process

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.
by rozef
Wed Mar 06, 2013 2:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code for creating Dyamic Subsets with Process
Replies: 19
Views: 3182

Re: Code for creating Dyamic Subsets with Process

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...
by rozef
Wed Mar 06, 2013 10:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rolling Average for Quarters
Replies: 11
Views: 2438

Re: Rolling Average for Quarters

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...
by rozef
Wed Mar 06, 2013 10:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code for creating Dyamic Subsets with Process
Replies: 19
Views: 3182

Re: Code for creating Dyamic Subsets with Process

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/infocenter/db2luw/v...
by rozef
Tue Mar 05, 2013 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rolling Average for Quarters
Replies: 11
Views: 2438

Re: Rolling Average for Quarters

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.
by rozef
Tue Feb 19, 2013 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reverse Allocation
Replies: 15
Views: 2908

Re: Reverse Allocation

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'] % ...
by rozef
Mon Feb 18, 2013 10:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Startup Error - Maximum size of rule reached
Replies: 11
Views: 1901

Re: Startup Error - Maximum size of rule reached

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 ...
by rozef
Mon Jan 14, 2013 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Problem
Replies: 3
Views: 666

Re: Feeder Problem

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.
by rozef
Thu Jan 10, 2013 3:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Problem
Replies: 3
Views: 666

Re: Feeder Problem

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 can't know in which...
by rozef
Mon Dec 03, 2012 10:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to select top level elements
Replies: 4
Views: 1483

Re: MDX to select top level elements

Hi holger,

this should work:

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

level.ordinal refer to generation starting by 0.