TM1 Forum

Good Morning everyone from Germany, I'm trying to describe what i want to do... What I've got: * A Cube with 6 dimensions, two of them are 'Year' and 'Month' * A Value on leaflevel depending only on Year and Month, the Measure is "Price" What i want to do: * I want to write a Rule, which c...

Hello again,

the solution was quite simple. The installation obviously did not replace the xla. I got it from a kind person from IBM, replaced it myself - et voila - it worked.

It's Version 9.41 FP, yes, not 9.1.4

Roger

I already supply all parameters, including the optional Alias-Name. Can't be the reason.

Hello everyone!

I got a strange error after upgrading to FP1. When doubleclicking an Excelcell containing a SUBNM Formula, a messagebox informes me, that the macro "EvaluateArg" cannot be found.

Has anyone stumbled over this and found a solution?

Regards,
Roger

Hi everyone, I've got some problems generating a view via TI . Whatever I try, ViewSetSkipCalcs() and ViewSetSkipRuleValues() seems not to work. Any hints on this? I create the view, i open it in the cube viewer and nothing changes? Do things work different in 9.4 ? SubSetCreate('Jahre', '_Jahreskop...

Why dont you simply delete all elements from the dimension via TI and replace them with the correct hierarchy? if the measures are saved to the same elements, no values are lost.

Take a look at DimensionDeleteAllElements in the Help Files

Thank you very much, this is exactly, what i was looking for. I didn't knew the function...*cheers*

Good evening everyone from germany,

how do i find out, if an element is child of a parent, regardless of dimension levels? ELISPAR won't do the trick, any suggestions?

Roger

Create a Subset via MDX which filters Measure <>0, then use this Subset in a view to snapshot your Excelsheet

Any News about this? Looks like the editor the world has waited for...

Well, i reconsidered completely and found a different solution thanks to a hint given by a colleague why build a view and sift through it, when i can filter the dimension directly via MDX? {FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [Kostenstellen] )}, 0)},[Kosten].([Jahre].[Alle Jahre],[Monate].[Jahr...

Oh, no need to speak german to me, i hope, that my english is not too bad... my solution from above did crash the tm1sd.exe - any ideas why? I'm using 9.4.0.568 What i've done now, is: a) create a second process, which uses the created view as a data source b) included a call to this second process ...

Okay...i found a workaround, BUT this crashes the tm1sd.exe - any idea why? Nothing special in the logs... -------------------------- iSubKostenstellen = SubsetGetSize('Kostenstellen', 'N-Elemente'); iSubKostenarten = SubsetGetSize('Kostenarten', 'Abgrenzungskonten'); iSubKosten_Zaehler =1; iSubKont...

Thank you very much to both of you

...in a view? Hi there, how can i find out, what elements are show in a dimension column in a view? What i've done so far, was to create a view via TI with Zero Suppression turned on. I now want to know what members are show in the dimension column (after zero suppression) to build a new subset of t...

Thx, but it seems, the problem is using the alias name. if i use a recorded expression in subset editor, it works, if the aliases are activated. the principal name does not contain the searchpattern, so without alias, no members are returned. i don't think it's caused by the german special character...

Hi there, i'm quite lost with building a subset in a TI Process. What I want to do, is to filter the elements of a dimension called "Kostenstellen" by a pattern ("*Fst*")in an Alias called "Bezeichnung". The Principal Element Name does not contain the string, only the A...