MicroStrategy / mstrio-py

Python integration for MicroStrategy
Apache License 2.0
89 stars 59 forks source link

Managed Objects? Not in list_ search results and errors if you dig the long way. #102

Closed hustontrevor closed 1 year ago

hustontrevor commented 2 years ago

It would be very useful for audit purposes to be able to see into the "Custom Query" table.sql_statement of our SuperCube objects.

Maybe just disable update functions but let us look at them?

cubes = list_all_cubes(conn)
for c in cubes:
    if c.name == 'My supercube dependent on Managed Objects':
        print(c.attributes)  #shows all the Attributes and IDs
        for a_dict in c.attributes:            
            a = Attribute.from_dict(a_dict,conn)  
            print(a.name)  #works
            print(a.attribute_lookup_table)  #IServerError: Unsupported Attribute. We do not support Data Import Attribute, MDX Attribute, Recursive Attribute, etc.
            for f in a.forms:
                print(f.expressions)  #IServerError: Unsupported Attribute. We do not support Data Import Attribute, MDX Attribute, Recursive Attribute, etc.
urszulajaczewska commented 1 year ago

Hi @hustontrevor, we'll investigate this issue and let you know when we have an update.

urszulajaczewska commented 1 year ago

@hustontrevor fix will be available with Thursday release this week