TM1 Forum

Hello, I have created a cmd and vbs script that opens up excel, runs the N_Connect macro. This cmd is attached to SQL agent.This has been working fine for 2 weeks until IT installs Cisco Communicator v8. Now my spreadsheet is saved with #VALUES indicating it is an access issue. The sql agent has a s...

Thanks that worked!

I have a calendar cube that has the Day, Month,Year and measures dimension. Cell P$9 ="F"&DBRW("tm1prd:Calendar",D$7,D$8,D$9, "Forecast Week") where D$7=DAY(NOW()) D$8=MONTH(NOW()) D$9=YEAR(NOW()) This works fine.Its gives me F1,F2 etc However, when I use the cell i...

For the millions who will benefit, here is what i discovered, the rule will work if the attribute is a text. Somehow if the attribute is a numeric,it will not even grey out even though the syntax is accepted by the rules editor

TTTTTTTHHHHHHHAAAAAAANNNNNNKKKKK YYYYYYYYOOOOOOUUUUUU !!!!!

That was a typo sorry.Below is the right one

['ReportSign']=N: IF(ELISANC('account','A110000',!account)=1,-1,1);

Hello,
I have this rule in a dimension

['ReportSign']=N: (IF(ELISANC('account','A110000',!account)=1,-1,1);

But it doesnt seem to take.Can anyone tell me if its a syntax issue? or if I cant use ELISANC in a dimension rule

Hello,
If I have a rule that calculates a value for Jan and then in February, I STET that rule for Jan. Will the calculated values be retained?

Hello All, I have an ODBC drill through that works for Excel cells with formula =DBRW(dim1,dim2.,etc).However, when the cell contains =-DBRW(dim1,dim2.,etc). The negative sign causes the drill through function not to appear.Currently, the drill assignment rule is [Version:'Act']=S:'P&L'; Do I ne...

Hello,
I would like to extract all the children of a roll-up. I know there is no loop in a TI.
Does anyone know of an alternative?

I have thought of that idea but we have several hierarchies for different business groups so 1 product could belong to many hierarchies.

Hello, I am trying to write the prolog to deal with scenarios where the consolidated element is selected for drill through. For example, the product hierachy is Total Product - AA -1101 -1401 -AB - 2301 -2411 -AC -3813 -3555 Sql query = Select * from dbo.GL where product ='?pproduct?' I want the res...

yup, realised the 'alias' bit after i posted this.
Solved the problem by turning the atrribute into an alias...

I have a month dimension that has Jan,Feb,Mar,etc with attributr Mthcount as 1,2,3 etc. I am trying to write the code to get previous month name. prevmth=numbertostring(ATTRN('Month',pmonth,'MthCount')-1); prevmthname=DIMENSIONELEMENTPRINCIPALNAME('Month', prevmth); The asciioutput for prevmthname i...

Hello,
Can anyone show me the syntax for the left hand side of the rules where there is a space in the dimension name

[ region:'AUS', cost center :'10', 'A111111']=N: .....

I am getting an error in the cost center section

Hello, I have the following structure in the product dimension PROD GROUP -> PROD CAT -> (PROD CAT) (SUB-CAT) -> (PROD CAT) (SUB-CAT) (PRODCODE) I have the code below where TPByCatChild=(PROD CAT) (SUB-CAT) (PRODCODE) ATTRPUTS(vsubproductname,DimName4,TPByCatChild,'ProdDesc'); And I have a rule that...