TM1 Forum

Is there a way to export the sign that is used for a measure in a consolidation in TM1Py?

I am not sure if a star schema is what I try to accomplish. I would like to drill down on aggregated accounts, so for example I would like to take all data from account '1', then drill down to account '2' and '3', which when summed are account '1'. Example, list of accounts in TM1: 10 |_333 |_432 20...

One option I now consider is to create a view with consolidated accounts and a view with unconsolidated accounts and use either for a specific purpose. However, it would be great if you could roll-up/drill-down in Power BI as you can in TM1. In TM1, I can select a view that has all levels of subsets...

Any suggestions? Maybe using 'get_members_under_consolidation'?

Hi!

The link is successfully made, thank you for your help!. However, I am now struggling to transfer the consolidations of the TM1 database to Power BI. What would be the correct way to be able to drill down on the consolidations in Power BI?

Thank you for the recommendations! I have managed to import individual dimensions into Power BI. I have been following this tutorial: https://code.cubewise.com/tm1py-help-content/getting-tm1-data-into-power-bi However, now I am struggling to get the Measures data into PBI. from TM1py.Services import...

I managed to create a connection to the TM1 database through TM1py! Another question. I am trying to come up with a MDX query that will provide me with columns that have the dimensions as header. The dimension 'Product' would become the column 'Product' and would need to be joined with the other col...

Thanks for your response! I am now trying to connect to the TM1 instance. I need a http port number and I am unsure where to find it. I have found that 9510 leads to the web application of TM1. I also tried 5898, 5895, 12345 and others since these seem to be default. If I understand correctly I shou...

Thanks for your response! I am familiar with Python so that's already something. I would like to create a local TM1 instance to run some tests. Do you know if it's possible to create this without the need to buy and install the IBM Cognos software?

I would like to connect our TM1 instance to Power BI. I was wondering whether someone has done this before and has any guiding tips for the process? I think about using the Python library TM1Py. Any other suggestions?