TM1 Forum

TM1 endpoints: Cube View: /api/v1/Cubes('" + cubeName + "')/Views('" + viewName + "')/tm1.Execute?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells($select=Ordinal,Value) MDX: /api/v1/ExecuteMDX?$expand=Axes($expand=Hierarchies($select=Na...

(Mod, please move this to the appropriate forum) Hi all, I am .Net guy, and I've recently found myself with professional opportunity to be the primary TM1 guy in our operation. I've been playing around with the TM1 REST API, and been very interested in the most efficient way to parse cellsets from M...

Hi there, I've been able to prototype writing into TM1 using the REST API with VBA. Would love to discuss further. Sub Example() 'Configure element list (Dimension~Hierarchy~Element) Dim elementList As New Collection Set elementList = Nothing elementList.Add "MONTH~MONTH~2212" elementList....

Very cool Edward!! Thank you for sharing.

Wondering if you may be available to chat about PAW.

Interested to see if you've been able to parse the JSON return of a cell set. From what I've found, you can query for axes collection object, and cells collection object. Axes collection has the hierarchical header values for columns and rows, and cells collection has the cell ordinal # and value. F...