TM1 Forum

Hi, Just checking to see if anyone's got a better solution to an additional reporting requirement that's been requested. We have a project dimension that lists (surprise, surprise) projects. There are some additional attributes that will be attached to those projects such as sector and location. The...

could never get it working in Perspectives but it worked in TM1Web Well what do you know!? That's exactly what I'm getting after uploading the file to the applications folder. Works fine in TM1 Web, but still no go in Perspectives. Now if I can just conquer all the Web formatting issues that just m...

Hi Tomok,

I figure the whole string must be being passed through, as until I got all the brackets in the right place at the very end of the concatenated string I was getting no results in the set at all. I can't prove that in any way though.

Mike

Hi there, I'm scratching my head over some MDX that I'm trying to use in an activeform. If I copy the MDX string and paste it into the subset editor I get the expected results, but using it in an activeform leaves project codes that should be excluded. Here's the (fairly long) MXD statement built fr...

Hi Tomok, Lotsaram (and others) It looks like you are populating a flag called "Project in Construction" with a value of 1 whenever the project starting and ending months are between a month range inside the Finyear dimension. This pretty much perfectly explains what I'm doing. The Timing ...

Hi, I'm struggling to work out how to feed our Project cube based on this rule: ['Forecast', 'D001','Project in Construction']=N: IF ( ELLEV('Project',!Project) = 0 & ELISANC('CCL Project','Sys.Level 2 Projects',!Project) = 0 , IF( NUMBR(!FinYear | ATTRS('Period',!Period,'Month No')) >= DB('Proj...

We finally got this to work.

Not sure what's up still and where the problem really is, but by dropping the string parameter and sending just the two numeric ones it works. Luckily at this stage we can hard code that string parameter in the SP.

Hi Tomok,

No, that still fails with the "SQL Statement Failed" message, both with and without the 'exec'.

The same query works from Excel as a data connection, so the parameters would appear to be in the right format.

Mike

Hi, We're trying to use an SQL Server stored procedure as a data source but having trouble getting it to work with parameters. Currently the TI sql Query window looks like: exec wbContractForecastPMRArr '5022', 2015, 11; This results in a very useful "SQL Statement Failed" error report. We...

Oh yeah. Updated to use SubsetCreateByMDX and it's all good.

Thanks for the nudge!

Mike

Hi all, I'm trying to create a subset containing only level 0 elements from a consolidation in a TI process using the following code: ## Build branch subset ## vString = 'Trading Branches'; Dim = 'Branch'; If (SubsetExists(Dim,vPrefix)=1); SubsetDeleteAllElements(Dim,vPrefix); Else; SubsetCreate(Dim...