TM1 Forum

Google (or ChatGPT) will help as .xlsx to .csv isn’t exactly a tm1-specific problem to solve.

If you have access to Excel and access to TI, why not “save as” in Excel to CSV? If multiple files, I suggest writing a VBA that automates this within a chosen folder. You may be able to build a VBScript (or other solution) and then trigger the .xlsx to .csv within TI using ExecuteProcess.

Two. However, I remember getting weird issues with some client apps, so I always do at least three.

Nothing. You have to hit enter first.

After you hit enter, 10 will replace each of the cells in that cell and to the right. In this case Total Year will now equals 120.

- In PAFE, report definition for: Quick Report, Exploration, Universal Report, as well as parameter for functions e.g. TM1SET - In PAW, report definition for explorations and all other visualizations - In TM1 Server definition for subsets/sets and views, as well as input for various Turbo Integrator...

Send an email to entire company that they have to resubmit their budget due to a catastrophic failure. That and pray to Manny that I don’t lose my job.

Elessar wrote: ↑Fri Feb 23, 2024 4:17 pm(I believe "!Employee" is a typo in your answer?)

Sorry, I copied your feeder statement and only adjusted left of the =>.

Elessar wrote: ↑Sun Feb 18, 2024 12:20 pm OK! But why does "Trace cell" show "fed" with my feeder?

Source is feeding, but not to the target cell shown in the function, which is seemingly a live functional statement.

Also feed from Job Type - it’s a string cell so any change to it will cause FEEDER to trigger and re-trigger:

THAT aside, keep your expectations with VBA/PAfE interactions low. VBA is practically undead at this point and is fairly limited in how it can interpret responses from REST/PAfE. PAfE itself is notoriously undocumented and a few of the core functions (like TM1ELLIST) don't behave as described. Resp...

Short-circuiting is the concept here, and not every language implements that. VBA also does not for those using PAXAPI.

lotsaram wrote: ↑Tue Feb 06, 2024 3:03 pm I'm not convinced that being able to create users but not have the user accounts be properly active and able to be used (that is log onto the system with the account) is a really useful feature.

Agree - either don't separate, or there should be an Invite T/F column in the CSV.

Just wanted to memorialize something I ran into today for benefit of others in the future. For PA on IBM Cloud (PAOC, IBM SAAS), there's two ways to add users in PAW: Manually creating them one-by-one using the Invite button -or- Uploading users from a CSV. When you use Invite button it's one stop s...

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...