TM1 Forum

Our BI environment is setup to use the Active Directory and Single Sign-on, so in a normal logon, the user is never challenged for credentials. However, thus far, I have not found a way to use the TM1SystemServerConnectWithCAMNamespace function with a null or blank password. You may have a bit of a...

So if you avoid rules for the reasons of performance (see Lotsa's post) then you're left with TI to push numbers from Detail to Summary. However if you are allowing for adjustments in one or more cubes (plus potential overlays for special audiences) then you're not really ever going to be able to gu...

So you're storing the mapping between Accounts and Activities outside of TM1? And you want to tap into this data set when you run the allocations? And you are wondering if you can use a DB() or CellGetN() type formula to tap into a data set sitting outside of TM1? The answer is no to the last questi...

would you have users write data to the Detailed cube, which then flows on to the Summary cube... or would you allow users to write topside adjustments to the Summary cube, which then backfeeds to the Detailed cube? Sounds like you're not clear on the requirement - what if some users want to adjust ...

JamiseBondi wrote:There are about 6 workbooks that have these problematic tabs that don't render images.

So you have some workbooks which render images ok, and some that don't? What have you looked at in the problem workbooks that might make them different from the ones that render the images?

Why don't you just state the business problem and the real dimension name - you're not giving anything away if you have accounts and business units etc like almost everyone else does. By presenting the question as a 'homework' problem, you're making it hard for people to give you answers because it ...

sOriginalString = 'jan 14, jan 15, jan 16'; sToken = 'jan 15'; sNewToken = 'santa claus'; nTokenStart = SCAN ( sToken, sOriginalString ); IF ( nTokenStart > 0 ); sNewString = SUBST ( sOriginalString, 1, nTokenStart - 1 ) | sNewToken | SUBST ( sOriginalString, nTokenStart + LONG ( sToken ), LONG ( s...

You can get that fairly simply without the need for very complex MDX. To be fair, it's not just the complexity, but the workaround involved. The sample MDX I wrote has a bit of a problem with e.g. Acton and Clacton-on-sea, or Eltham and Feltham (London place names for those unfamiliar) as the INSTR...

Did you try cell security on the }ElementAttributes cube data as opposed to element security on the attribute itself?

You need to use string comparison in the FILTER function to get around the 'incorrect dimension for subset' error. This will work to get the parents in Office matching a defined subset of n-levels in City: Filter ( TM1FilterByLevel ( TM1SubsetAll ( [Office] ), 1 ), Instr ( SetToStr ( TM1SubsetToSet ...

Sorry to nit-pick, but your question is ambiguous due to: 1) Dimension "Summary" contains a hierarchy of All > Continent > Country and The puzzle is thus: 1) Perform an MDX query on the "Summary" dimension a) Filter by wildcard country e.g. "UK" b) Expand out to find al...

Ok, but how to write a rule that will apply ATTRS function on every date/team leaf element. Use the N: qualifier in the rule - this is one of the reasons I asked if the time dimensions were the same or different. Using N: will make the rule act only at the leaf level of the cube. So, you write the ...

Is Date_Dim the same in both cubes or do you have separate dimensions? Is one with a n-level of month and one with a n-level of date? Or, are you storing margin % at a consolidated level in Margin_Cube using string elements, or other calculations? It makes something of a difference to the answer.

It's possible, in a partial way, but you need to bounce the server to get TM1 to rebuild the application folder tree from the content in }Applications within your data directory. The following code will build a file in }Applications that will create the entry post-re-start. There's several different...

I sorted a Dimension by an alias. a) {TM1SORT( {TM1SUBSETALL( [DimName].[Alias] )}, ASC)} b) {ORDER( {TM1SUBSETALL( [DimName] )}, [DimName].[Alias], ASC)} Result: Both mdx-Statements sort the dimension. Both mdx-Statements sort differently. Does somebody know the differences between TM1SORT and ORD...

Thanks guys, indeed I mis-read it like they'd totally forgotten the password.

BariAbdul, I think you are over-reaching. You should just try and write one TI where you can copy cube data from one slice to another. Once you've conquered that step, you can continue to the more complex operations e.g. mixing numeric and string elements in the copy process. The code you presented ...

This method will be more version agnostic: Option Explicit Declare Sub TM1SystemBuildNumber_VB Lib "tm1api.dll" (ByVal str As String, ByVal Max As Integer) Public Function GetTM1ApiVersion() As String Dim strVersion As String strVersion = String(100, Chr(32)) TM1SystemBuildNumber_VB strVer...

I would very much welcome to be able to select only the elements in the current subset (in the rows dimension) that really have data after zero suppression. Say, 200 elements out of 1000. I used the 'Filter by View Extract' function on the subset editor to do this today. It was on }ClientGroups - s...

SecurityAdmins cannot assign people to the Admin group, including themselves. Nor can they assign themselves to DataAdmin. The classic route out of this trap is to restart your server without }ClientProperties.cub. In the process you will lose all the passwords so you need a smart strategy to reset ...