Search found 2 matches

by JoshLobel
Wed Jan 03, 2024 1:49 pm
Forum: Free And Open Source Tools
Topic: Can TM1py return Alias values rather than base member in MDX
Replies: 2
Views: 2819

Re: Can TM1py return Alias values rather than base member in MDX

First of all, and not to clutter things further - sorry for posting this item in the Free and Open Source Tools. I misunderstood its purpose. But second, now that I did, I just wanted to thank @asheevel for their response. using the execute_mdx_data_frame_shaped with the display_attribute=True did j...
by JoshLobel
Wed Dec 20, 2023 2:32 pm
Forum: Free And Open Source Tools
Topic: Can TM1py return Alias values rather than base member in MDX
Replies: 2
Views: 2819

Can TM1py return Alias values rather than base member in MDX

Hello, I have been trying to populate a simple dataframe with }Client info on the rows. I have MDX that looks like this: mdx = """SELECT NON EMPTY {TM1SUBSETALL([}Groups].[}Groups])} ON COLUMNS , NON EMPTY {TM1SUBSETALL([}Clients].[}Clients])} ON ROWS FROM [}ClientGroups] ""...