TM1 Forum

Ian Thanks for the link - I did spot that and had a quick look at the VBA (charmingly parsed btw). However, I'm looking to create the "big brother" to your macro sheet, covering all file types (especially the pesky .blb and .blob) and 'shadow' objects created by TM1 Contributor apps. Also,...

Thanks to all for the responses. In order to give due credit and answer some very prudent questions asked: Tomok - not recursive to my mind, just 2-stage, whereby the results from one dimension's query become the SubsetToSet starting point of the second dimension's query Mack - thanks for the detail...

Ian That is true; I could create a 2D cube and populate with strings or 1/0 flags to indicate intersections, then write the MDX to use this as a filter. However, I was hoping to be more elegant than this (partly as the resulting MDX subset is only *part* of the overall goal, and that both of these d...

Good spot Mac - now corrected to remove ambuguity in my example.

Summary hierarchy is now Country > City
Detail hierarchy is now City > Office

Hello all Been a *looong* while since I've been on here, and I some seeking your advice on MDX :? :shock: I've done the usual forum searches and reread the MDX Primer half a dozen times, but can't crack this one :( . All help/ideas/comments gratefully received. Q: How do you pass the resulting set f...

All I would appreciate it if someone running v9.5 could perform a quick test involving a websheet with an action button for me - to make sure I'm not missing something obvious or encountering a particularly unique environment / configuration issue. 1) Create a new Excel sheet with some TM1 formulae ...

Appleglaze To follow on from Alan's comment, I fear that your description is still quite confusing! However, if I had to take a guess as to what you're trying to do, which looks like you're trying to "daisy chain" minly different processes together which have only one common parameter: 1) ...

Steve As the rule trace seems to reference the correct 2 values on each occasion i.e.: 1) Somme pour Moyen = 315.5 2) Period Populated = 12 It seems to be simply the "divide by" operation which is going askew. Looking at your rule code, a suggestion I may offer is to fully qualify the ['Pe...

Update for those who have been able to follow the jist of this thread! I have managed to combine the 2 perviously obtuse MDX statements to give the following "working" statement: { FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL([Calendar])}, 0)}, ScenarioCalendarControl.( StrToMember("[}Cli...

Mario If you are loading data which is used to feed large volumes of your cubes, you may notice that the upload speeds are severely reduced, as TM1 evaluates and feeds for each cell updated by your TI process (in v9.5 at least). For example, if you load a single record for "today's USD:EUR rate...

Lotsa Thanks for the response. It seems I was working toward your way of thought independently, having created a cube which uses rules to do the "heavy lifting", but with a few more dimensions. On paper, I believe your suggestion (and my own attempts) would be functional. However, 2 points...

All It has been a while since I've been around, and after much forum scouring and Google hunting, I pose the following MDX puzzler for your deliberation... Aim: I am looking to generate a MDX subset over the "Calendar" dimension which returns the years between a 'Start year' and 'End year'...