The VBA macro recorder does not track any actions in the TM1 ribbon.
So how can I publish a report with TM1 menu operations using VBA?
Is there a list of commands available like using
Code: Select all
Application.Run("TABDIM", sCube, i)
Code: Select all
Application.Run("TABDIM", sCube, i)
Respectfully disagree on the VBA point - lots of big business has VBA in their workflow, that's why Microsoft keeps it going.20 Ton Squirrel wrote: ↑Thu Feb 08, 2024 9:32 pm 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.
Code: Select all
Dim apiHeader As String: apiHeader = "/tm1/xxxxxxx/api/v1/ExecuteMDX?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells($select=Ordinal,Value)"
Dim apiBody As String: apiBody = "{""MDX"":""SELECT { [}ElementAttributes_xxxxx].[}ElementAttributes_xxxxx].[Element Name] } DIMENSION PROPERTIES MEMBER_NAME ON 0, { [xxxxx].[xxxxx].[xxxxx].Children } ON 1 FROM [}ElementAttributes_xxxxx]""}"