TM1 Forum

I just wanted to say that I have been using bedrock TI (up to v4) professionally as a TM1 consultant/developer for at least 10 years in a large number of organisations, in big production environments and cannot think of a single instance of any of the processes malfunctioning. Every time I thought ...

lotsaram wrote: ↑Wed Sep 06, 2023 11:07 am Why would a new user with no post history necromance a thread from 6 years ago just to troll someone? Very weird stuff. Maybe it's a chatbot/trollbot?

Was thinking the same thing.

Wim Gielis wrote: ↑Wed Sep 06, 2023 4:10 pm
Like the CubeNext function in TI

Did someone ask for me?

That is not currently possible.

The only way would be to add an element to your column dimension (perhaps named “Selected”), then if a user inputs a value or picks a value in a picklist, you can programmatically identify which elements have been selected.

The only thing that comes to mind for open source OLAP is this recent blog post: https://community.ibm.com/community/use ... source-tm1

Hi Chris, Maybe Bedrock is suited for this exercise ? This. I'll help you, this is adapted from what we've used in production for multiple years. Put in some extra # comments for you. Let us know you make out. # Version dimension sVersionDim = 'Version'; # Iterate through all cubes to find ones with...

Here are some useful batch scripts for IBM Planning Analytics for Excel (PAFE) Operations. Can use this as baseline to automate install / setup / deployment / configuration of IBM PAFE to end users. If you don't want to run in Windows Command Prompt or Batch file, you can review the below and naviga...

Ran into another issue today that isn't 100% related to Classic add-in (so adjusted thread title) but thought this was the best place to document it as the symptoms are the same. For me this happened during a dirty Excel crash. Symptoms are: No references to IBM PAFE in the Excel Add-ins window. IBM...

Nice little use case: When creating an action button in PAW and you link it to a process, when setting parameter picklist, you cannot specify control dimension, e.g. }Clients. So pick some other dimension, then do Ctrl + Q + / and you can find/replace all references of the dummy dimension with the i...

I had a case where users need to track a measure as a percentage of Sales Revenue. Adding a rule to do this across any number of scenarios, periods, SKUs, Customers etc. etc. would have added huge calculation overhead. Rarely do we disagree, but here I am on the same page as Steve. For us this woul...

Steve Rowe wrote: ↑Tue Oct 11, 2022 2:52 pmI'm genuinely interested if there are use cases where an MDX view can deliver things that are not possible or obviously better than in a rule / consolidation?

I've started a new thread: https://www.tm1forum.com/viewtopic.php?t=16328

I wanted to start a dedicated clean thread to discuss a great topic: I'm genuinely interested if there are use cases where an MDX view can deliver things that are not possible or obviously better than in a rule / consolidation? I would encourage friends to provide other use cases. Likewise it would ...

Hello, One possible work around is to send everyone to the same book, which has general information, announcements, and also a button that says "click here to begin". The button doesn't actually do anything, rather the magic is a 0% visibility overlay of a websheet which has a single cell,...

Question 1 : they have 2 dimensions YEAR and VERSION and they want to make a calcul for exemple : VERSION A YEAR 2022 - VERSION B YEAR 2021 ==> is there any way to do it on exploration view? (when i try to insert calcul, i can only chose 1 dimension) The MDX engine in TM1 is very powerful, so doing...

I do not want to show any values at consolidated element "Measures", because it would be misleading since children of this Element are just different measures (some are percenteges, some not etc.) Elaborating on what Wim rightly suggested, a good rule of thumb is to set the weights to zer...

Recommend running a fiddler trace to get the specifics, but yes when you move in PAFE QR grid from cell to cell there’s some jitter.

This is a good one, not sure why this is hidden away. Might be a good IBM PA AMA question for next time.

I’ve also used this for pixel perfect column width across sheets, which can be important for some users.

We’ve not seen that issue before. Would you post some VBA for us to look at?

What I did notice is that Quick Reports created on PAX 73 have an extra 3 rows at the top: Host TM1 Server Cube This is not the case with QR created with PAX 62. I think this is causing the issue, will investigate more when I have time. Indeed that is correct. We had to work around an issue with re...

After updating the dimension filters (subnm), the user press a button that calls a VBA code that test some things, rebuilds the sheet , build the MDX, and query the data. But we've been getting an VBA runtime error '91 object variable or with block variable not set" on this line: Hi Luiz, Want...