TM1 Forum

Palo PR Interesting development? Jedox, an international software company that develops and markets commercial, open source-based planning, analysis and reporting solutions, has announced a new development for its Open-Source OLAP Palo product - the industry's first free ODBO driver (MDX) in the cos...

1. Can Palo link to TM1 view to load data instead of reloading them from warehouse and/or operational systems? I'm not quite sure what you are asking here, but you could for example do a palo.setdata (equivalent of DBS) from a spreadsheet, although the two add-ins don't co-exist totally happily. It ...

Ask away that's why we come here :-) whats the best material to read to get started with Palo? Weeeeeelll..... I think I'd start with the manual :-) You do have to pay 30 Euros for that but it is worth it. There is also some basic "about Palo" material on the Jedox web site. (www.jedox.com...

Well it's 7.44 now Alan :D not sure how much work is involved in converting the models from TM1 to Palo. Very little - The structural design is the same (give or take the discussions around architecture and object locking that I have been reading, but if you have a basic model your cubes and dims wi...

However for a "mission critical" application, especially for larger companies, you may be better sticking with a larger supplier (Iboglix) which can give you support when you need it. Ahem. According to Mr Pendse smaller vendors perform significantly better in support than larger ones. In...

My cat purses his lips when he hears the noise from the Eurofighter so it can be hard tell what direction he's facing in

New info from Jedox We have some exciting developments to announce in regards to our free-of-charge Open-Source OLAP Product Palo for Excel. We decided to include an ODBO driver (MDX) in the free download of Palo for Excel . The new ODBO connectivity allows to access Palo OLAP cubes via Excel Pivot ...

Ach, just cause I don't post doesn't mean I don't keep my eye on it

While you're on can you have a word with the guys who sit at the front of your Eurofighter thingies and ask them to turn down the afterburners whilst they are flying over my house. I swear they make our foundations shake.

Your best bet is probably to attach some VBA to a button with a mixture of conditional formatting, and setting the Excel locked property based on an elapsed period flag.

Not totally dynamic I grant you.

Hope this helps

John

=SUBNM("Server:Dimension", "Subset", row()-row($a$1)) Subnm is the TM1 function to return a subset member according to What server & dimension you select as Server:Dimension An index number (of the element within the subset) The row() function is Excel row() with nothing in t...

Assuming you have the dimension name available then

=SUBNM("Server:Dimension", "Subset", row()-row($a$1))

(Where row($A$1) might be different depending on what row you start the list on)


Should get you a list to use a a validation source

Been trying in the IBM product download page but I'm lost.

Cue - Alan.......

Hi Reddy - it's quite easy in concept to copy a single source value You need to capture the source value an assign it to a variable then: 1. Loop through the target area cells 2, With each cell.. 3. Test if it is a DBR / DBRW 4. If not then next cell and goto 3 5. Capture the formula in the cell and...

I may be missing something here but can you not just cycle through the dimension elements using a counter Then have a variable like sTest = Dimnm(Dim, Counter) Then use string rules to test if the the first 8 characters of sTest are equal to "210EXAFR". If so drop them into a subset. Looks...

Well we all said that being taken over by a company with all of the resources of IBM would be a shot in the arm for TM1 support and development.

I guess we just didn't expect it to be full of strychnine

http://forums.olapforums.com/viewtopic. ... =max#p2739 ?

If your cube is quite small and dense then then the overhead of writing and maintaining feeders mat well outweigh the benefit that you get from them. Be aware though that although it is quite legitimate to NOT have feeders, certain functionality doesn't work properly without them - you need to be ve...

I can't see this working without a third element (some sort of flag) Presumably the calculated result of Dollar or Hours could = 0, so I can still see potential circularity in you current method If you use this kind of logic: FLAG = 1 Sales Budget = if flag = 1, Stet, Sales * Increase % / 100 increa...

NOOOOOO..... That's not what I meant ( and I am sure you know that). Rebecca as in the first Mrs de Winter.

I did indeed get the Du Maurier reference.

You've slipped out of character by the way

I was thinking more Rebecca

Ms Hansen will no doubt be over the moon (if she still reads this forum) to hear that an old salt still remembers her