TM1 Forum

Hi, I try to build an nice looking input dialog. So I want (Excel-Style) an input cell and a very small row below to have a delimiter for the input fields below. Unfortunately all settings belonging to row height in the pattern rows are ignored. The height of the first row in the data area is used a...

Wow.
Lets assume, I have a simple active report created by the View builder in Excel. Accounts in the rows (row header).
How could I react to a double click on an account name to do some changes, e.g. drill down or drill down?

Hi all, my idea is a report of accounts listed in the rows. Because the dimension is very large, only a few hand selected mayor accounts will be visible, any accounts below (children), will be hidden unless the user makes a drill down. How can I manage that? The MDX for building the entire report to...

I have a report, I like to publish or to update.
The VBA macro recorder does not track any actions in the TM1 ribbon.
So how can I publish a report with TM1 menu operations using VBA?
Is there a list of commands available like using ?

Hi, I want to have a Picklist for all used user defined dimensions. So I want a complete list of all elements, which would be: Dimension:DimName I also want to offer a list of all elements without the top level and a list without the leaf elements. Additionally I need to show attribute names defined...

Nice! Thanks!

:D After searching for hours and posting this question, I fould the magic "EXCEPT". { EXCEPT( { TM1SUBSETALL( [}Cubes] )}, { TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Cubes] )}, "}*") } )} Worked for me. But if anybody else will face this problem in the future again, here is the code....

Hi, I'm trying to define a Picklist for the user for selecting one of his own, non system, cubes. I know, I find the names in the }Cubes dimension. But there are also all system cubes, beginning with "}". Now I want to create a subset with all non }-cubes using a MDX statement. Unfortunatl...

You are totally right! I have the solution for an hour, and even now I want to improve it. :lol: And because this should be the base of a development for many reports, I like to get a very flexible solution before using it many times in many reports. So next step will be to restrict it to subsets, s...

Hi Steve, I think I got it. I created a Cube DB( '}TM1Config_UserSelection', !}Clients, !}TM1Config_UserSelectionDimElement ) where "}TM1Config_UserSelectionDimElement" includes all dimension names like "}Dimension". But in "}TM1Config_UserSelectionDimElement" I could a...

Wow, that sounds great. I don't have any experience with Picklists. So first I have to do some research for that. Thanks a lot! So I think, the picklist is set to the dimension "}Dimensions", because every dimension needs different selections, correct? Or is it placed in an additional mesa...

Hi, I know, that this is no new topic, but I found no solution. Given the scenario of a user using a report. He selects a product and a customer, then he switches to another report. There these selections should be set already. I know, that I can pass them by variables using "Addtional options&...

Thanks for your ideas and comments. I will try both variants and see, what feels better.

Hi Wim,
I already checked the code. It replaces an empty delimiter with a ";". That was the reason I asked, because I didn't want to change the original bedrock code.

OK, that may be a long term solution. My question was, if I missed a detail or if I should use the function differently, because I never think, that I was the first one, who discovered an issue. If it is not a bug, but it is a feature, I can live with that.
Thanks Wim!

I'm using SQL Server. So when importing, I can use a TI process reading SQL Server Table and transfer data into the cube. When inspecting Bedrock functions, there are only file operations for importing and exporting data to files. Is there a reason, e.g. performance? What's best practice using a SQL...

Yes, it works. Thanks a lot!

I try to use bedrock functions, whenever possible. When exporting values from a cube, there is a pThousandSeparator parameter. I want to set it to nothing, because in output I don't want any formatting. Just the numbers as they are, e.g. 12345.78 or 12345,78 if I need a comma. But if the parameter p...

That's simple: I want to run a VBA macro in Excel using TM1 functions.

I think I missed something basically. Installation?
I read about finding some files with .bas in cognis folders to use them first, but I don't have these files on the drive nor the folders they should located in.

Hi, I try to use TM1-functions using VBA in Excel. Despite all research in forums and Google, I didn't get it. When in VBA editor, I want to make a reference to an TM1 speciifc xla. But I only see the tm1p.xla. This is not enough. When running a statement like Set TM1Server = CreateObject("TM1....