TM1 Forum

Hi GROUP_CODE_DIM and CODE_DIM are both Title dimensions. I have SITES_DIM as the Row dimension and DATES_DIM as the Column dimension. I've created a subset of CODE_DIM with your code and no matter what value I select from GROUP_CODE_DIM, the CODE_DIM list doesn't change - ie, it always shows all of...

Hi,

I've tried that but the only thing that would work is something like:
Which, of course, defeats the object.

I'll leave it at that point and try to return to this at a later date

Andy

Hi, That's the post I've been trying to follow - but with no luck so far :( My subset's Expression is: {FILTER({TM1SubsetAll([CODE_DIM])},[GroupCode]=[CUBE_NAME].([GROUP_CODE_DIM].CurrentMember))} Where CODE_DIM is the name of the dimension containing the Code values and an Attribute called GroupCod...

Hi,

For now, it will be in the cube viewer.

Thanks

Andy

Hi All, I have a cube that has a dimension that contains hundreds of values. Even though these are sorted in a logical order, the list is too long to make it usable. This dimension has two levels - Group Code and Code. I've, therefore, created a second dimension that holds the Group Code values and ...

The interim fix mentioned is officially termed Interim Fix 1 by IBM, however there seems to be some confusion on IBMs part with the accompanying documentation which states IF2 in places. Another option might be to Open and close connections in a master process and run a sub-process to do the ODBC o...

Thanks, Gabor

I'm not sure what the build is that has just been installed - so have sent a request to find out

Regards

Andy

There is a known issue, which is addressed with TM1 10.2 FP1 IF2. PI09375 ODBC connections TM1 server leaves ODBC connections open to Oracle when the TM1 process fails I think you need to involve support to see if there is a Fix available for your version and if it catches your problem. Unfortunate...

Hi, I have a process that uses ODBCOpen(), ODBCOutput() and ODBCClose() If the ODBCOutput() function calls a procedure on the remote database and that fails, how do I ensure that the ODBCClose() function is always called so that the connection is always closed? I've tried the ODBCClose() in Prolog a...

Hi Tom, I'm sure the MDX functionality is invaluable - I am a novice at TM1, so the pages I looked at were mind-boggling to say the least! When I get the chance, I'll look further into it but, for now, I have something working that suits my needs. The only change I've made to the code I posted earli...

Hi Wim, Yes - I went to both of those sites. The first page was confusing but I tried everything from there that seemed to apply to my situation and couldn't get anything other than errors :( Following Declan's advice, I then found another page on the same site as your second page: http://users.skyn...

Thanks, Declan. Took a while to work out, but I found an example and ended up with: #****Begin: Generated Statements*** #****End: Generated Statements**** c = 'ATD_VIEW_TEST'; v = 'VIEW_2013_12'; y = '2013'; m = '12'; zM = 'ZeroOutMonth'; zY = 'ZeroOutYear'; # 1. Remove view and subsets if they alre...

Hi, Aarrrgghh! Trying to find anything anywhere that explains the syntax of the MDX Expression needed is really p*****g me off! Given the following: Cube: ATD_VIEW_TEST Dimension: ATD_MONTH - need to filter to "12" Dimension: ATD_YEAR - need to filter to "2013" can someone help w...

Hi All,

Thanks for the replies. I'm inclined to create and then destroy a view etc as well as it would only be used for this purpose and I don't like leaving behind what could become a small collection of views that are only there for admin purposes.

Thanks

Andy

Thanks Tomok, So, I create a view using the dimension values I need as a filter and then zero out the data in that view. Something like: VIEWCREATE (‘MyCube’, ‘SinceStartDate’); SUBSETCREATEBYMDX(‘Last2Months’, ’{ LastPeriods(-9999999, [MyTimeDim].[‘ | MyStartDate | ‘]) }’); VIEWSUBSETASSIGN(‘MyCube...

Hi, Is there a way to remove data from a cube based on the values in two dimensions? For example, suppose I have a cube with year and month as two of the dimensions and now need to replace that data, I want to ensure that the cube only contains the new data for that year/month and that any old cells...

Many thanks for all your responses, I'll go through them and try them all out to see what works for us

Thanks

Andy

Hi All, I have a Chore that runs several processes that populate dimensions and cubes. At the end of this chore I would like to run a process that sends an email to a user to confirm either that the chore completed ok or it failed. I've worked out how to send an email - but how do I identify when al...

Apologies for the delay - I've been trying the various methods to get something to work. Nothing worked, so I've agreed with the users that they are ok to slice the cube to a spreadsheet and use Excel filtering to get what they need. I can't see anything that allows me to flag this post as "Clo...

Thanks Tomok - That was why I tried creating an element at the same level as the actual values in the dimension and copied the data into that during the process - so that each "record" appeared twice, once as normal and once using ALL in place of a value. Tomok/Lotsaram.. I can't post a sc...