Search found 2 matches
- 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...
- 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] ""...