{"action":"reopened","issue":{"url":"https://api.github.com/repos/cubewise-code/TM1py-samples/issues/31","repository_url":"https://api.github.com/repos/cubewise-code/TM1py-samples","labels_url":"https://api.github.com/repos/cubewise-code/TM1py-samples/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/cubewise-code/TM1py-samples/issues/31/comments","events_url":"https://api.github.com/repos/cubewise-code/TM1py-samples/issues/31/events","html_url":"https://github.com/cubewise-code/TM1py-samples/issues/31","id":354770443,"node_id":"MDU6SXNzdWUzNTQ3NzA0NDM=","number":31,"title":"Alias extraction","user":{"login":"an5ir","id":42062013,"node_id":"MDQ6VXNlcjQyMDYyMDEz","avatar_url":"https://avatars0.githubusercontent.com/u/42062013?v=4","gravatar_id":"","url":"https://api.github.com/users/an5ir","html_url":"https://github.com/an5ir","followers_url":"https://api.github.com/users/an5ir/followers","following_url":"https://api.github.com/users/an5ir/following{/other_user}","gists_url":"https://api.github.com/users/an5ir/gists{/gist_id}","starred_url":"https://api.github.com/users/an5ir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/an5ir/subscriptions","organizations_url":"https://api.github.com/users/an5ir/orgs","repos_url":"https://api.github.com/users/an5ir/repos","events_url":"https://api.github.com/users/an5ir/events{/privacy}","received_events_url":"https://api.github.com/users/an5ir/received_events","type":"User","site_admin":false},"labels":[{"id":671176940,"node_id":"MDU6TGFiZWw2NzExNzY5NDA=","url":"https://api.github.com/repos/cubewise-code/TM1py-samples/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-08-28T14:56:57Z","updated_at":"2018-09-18T19:51:31Z","closed_at":null,"author_association":"NONE","body":"Is there a way to extract the alias of a dimension when using mdx  quay to extract a view?\r\n\r\n    with TM1Service(address='localhost', port=9611, user='admin', password='apple', ssl=True) as tm1:\r\n        mdx = \"\"\"\r\n        SELECT \r\n        {\r\n        [Date].[2017-01]:[Date].[2017-12]} on COLUMNS, \r\n        TM1DRILLDOWNMEMBER(  {[product].[001]},  ALL,  RECURSIVE ) on ROWS  \r\n        FROM [Bike Shares] \r\n        WHERE ([Bike Shares Measure].[Count],[Version].[Actual]) \r\n      \"\"\"\r\n\r\n        data = tm1.cubes.cells.execute_mdx_raw(mdx)\r\n        df = Utils.build_pandas_dataframe_from_cellset(data, multiindex=False)"}}
{"actor":{"display_login":"MariusWirtz"}}