TM1 Forum

Hello,

I have been trying to load CSV (and other flat files) but I cannot load them when TM1 is running as a service (as localsystem). I have no problems when i run it directly on the desktop.

Any ideas why this is and how to fix that?

Thanks,
DNA

Hello,

is there a way to increase the number of errors the error log accepts before "maxing" out?

I need to have a comprehensive list of the errors being through (not just the first 1000).

Thanks!
-DNA

I generally stay away from using "" in subsets simply because its not reliable especially if you keep changing whats in different unnamed subsets

Try creating a new subset (with all of the elements you want) and referring that in your Excel formula and see if that works.

So I've been trying to create this websheet based on an active form with a chart at the bottom. However, the rows are compressed so that they can dynamically expand when the user wants to see only the parents. The problem I am facing is that when the parent is expanded, the chart no longer uses the ...

Well, its not an alias at all... rather an attribute that is actually the used to determine which "Target" to select (i.e. for this Function, the Target Band is X). I am using the Target Band as an attribute of the Function... There is one target band per function but many functions per ba...

Well, I want this to be calculated at the base level but be aggregated at all of the levels above level > 0.

Hey again everyone, I seem to be getting a major headache from trying to figure this out and so I thought I'd reach out to the forum's resident brain trust. I am trying to create a rule that will look at an attribute and use it as a reference for what value to use as a "target." I have pos...

Hello, I am trying to run this code to compare a piece of text to select a particular calculation based on the "option" selected by the user but keep getting this error: Error on Line 4: Syntax error on or before ['Calculation Option Logical expression Here is the code I am running FEEDSTR...

As an update, I solved it... in case someone wants to use it, here's the generalized code: Index = 1; Reference_Dim_Size = dimsiz('Reference_Dim'); #while loop to cycle through all of the Resource Sponsors and create the subsets While (index < Reference_Dim_Size ); Attribute_Name = attrs('Reference_...

But now I need to figure out how to get the MDX statement to accept the SponsorName variable... any pointers? I am also trying an alternative approach (which is still giving me errors): Index = 1; SubsetIndex = 1; FunctionSize = dimsiz('Functions'); #while loop to cycle through all of the Resource S...

Nevermind! Got it to work!!! (See Code Below): #****Begin: Generated Statements*** #****End: Generated Statements**** Index = 1; FunctionSize = dimsiz('Functions'); #while loop to cycle through all of the Resource Sponsors While (index < FunctionSize ); SponsorName = attrs('Functions',DIMNM('Functio...

You need to move: SponsorName = attrs('Functions',DIMNM('Functions',Index),'Resource Sponsor'); inside your while. As written, it never changes after index 1. Matt As you suggested, I changed the code (below): Index = 1; FunctionSize = dimsiz('Functions'); #while loop to cycle through all of the Re...

the code below does create the first subset (albeit not dynamic) but does not create the subsequent subsets: #declaring variables Index = 1; FunctionSize = dimsiz('Functions'); SponsorName = attrs('Functions',DIMNM('Functions',Index),'Resource Sponsor'); #while loop to cycle through all of the Resou...

The part of the process I am having trouble with is "cycling' through the attributes to find unique attributes and create a subset of them. I tried a "while ( index > dimsiz('dimensionname') ) loop but to no available.

-DN

I get that part... the thing thats difficult is creating new subsets "automatically" as new "Sponsors" are loaded from data.

I promise to contribute to the discussion when I am more knowledgable about this but how would I write a TI process to create dynamic subsets for every change in values of a particular attribute. Lets use the example I used earlier: For every new "Sponsor" (attribute in the Organizations f...

Yeah... it really is... I might try to add this to the existing "load" process. Where it will add it to both the attribute in the other dimension AND the element in the measure dimension.

You could write a rule: ['Sponsorship'] = S: attrs('Organizations', !Organizations, 'Sponsor'); What are you trying to achieve? Capturing the data twice is (usually) redundant, you can report attributes in your reports if you wish, so there's no need for it to be stored in the cube. In general it's...

Interesting... a follow up then, instead of pushing the value from an element to the attribute, tried to load the element value from the attribute, would that be easier?