TM1 Forum

Thanks burnstripe for your reply! I hoped, I can leave the code modularly, in order to run Process1 and Process2 also separately. The amount of imported data might grow, so I hoped to avoid CubeSaveData, since it might take its time and downgrade my performance. Guess, I will play around a bit, to f...

Dear community, we are expanding our application/server by the use of TM1py. Guess, that for those of you, who work with it for years already, our current issue is familiar and you can help us: We have two processes: - Processes1 imports data via tm1py to a cube - Process2 transforms the data Both w...

Hi Wim,

oh, great! That's a good hint! Thanks a lot! This should make it possible to accomplish what I have in mind.

Hi everyone, there came something to my mind again: The Workspace User Interface API. By this, you could at least show a saved cube view in the internet browser: https://ibm.github.io/planninganalyticsapi/#showing-a-widget Though, you have to handle all the authentification stuff and you leave the E...

HI community,

meanwhile I was in contact with the IBM support. We examined that it was possible to delete the subsets after a re-login. And a chore was also able to delete the subsets.

But the whole issue was fixed in version Workspace version 2.0.94:
https://www.ibm.com/support/pages/apar/PH58579

Hi everyone, since Wims respond is some time ago, I was wondering if there are new possibilities regarding the original question, especially in the PA world. We would like to open a cube view in the cube viewer via VBA macro. Sadly, Drill-processes seem not to be the solution: https://tm1forum.com/v...

Hi everybody, although this topic is very old and claimed to be solved, I struggled this issue several times in several versions. Looks like IBM did not really solve this bug in a sustainable way: https://www.ibm.com/support/pages/apar/PI97815 Currently, I got this issue in version 11.8.01200.7, i.e...

Looks like the problem was caused in the old Internet Explorer. With Edge everything worked fine.

Hi everyone, we just did a version upgrade for the server (2.0.9.18), PASSL (2.0.88) and the architect. In the past we built a lot of websheets in Perspectives, some with Action Buttons. But they do not work in PASSL anymore! Since my customer does not work with PAW yet, we do not use PAfE and can n...

Hi,

maybe my quastion should be a new topic, but it highly related to this one.

How can I achieve the old Architect-behaviour in a PAW cube view? By default, a consolidation is just extended in the row I click. What if I want to extend it in all rows?

Hi burnstripe,

thanks for your idea.

Unfortunately my client does not have PAW, yet. Is there also a way to solve this issue in TM1-Web or PASS?

Meanwhile I found the following options: Sandbox-Mode of TM1-Top: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=utility-tm1-top-commands The TM1-Top log: Includes the parameter "TopScanMode.Sandboxes" to log sandbox activities. https://www.ibm.com/docs/en/planning-analytics/2....

Hi TM1 Community, exporting a websheet to pdf can be formatted by defining the print area in Excel during creating the sheet. But what about cube views? Is there a possibility to format the pdf export of cube views? Like freezing panes, at least. Without that, the exports are nearly useless. I'll be...

HI Wim, thanks for your reply! Hello, Did you check Bedrock TM1 coding ? There you will have examples on how to apply a certain sandbox. The problem is the point, that sandboxes are private. With "normal" code and commands I can only apply my own sandboxes. But burnstripes idea might be a ...

Hi everyone,

in my project a process chain is scheduled to run each night. I was now asking myself, whether it is possible to let this chore run not for the Base only, but also for every users sandbox.

Does anybody have an idea or even a solution for this issue?

Hi Tom,

thank you very much for your quick answer!
At least I know now, that there is no simpler way to go. I will try your second proposal, guessing it has less impact on the performance.

Thanks again!

Hi everybody, I want to export a view containing all leaf cells - including strings on consolidated level! Since the TI is supposed to work for various cubes, I define the source view in the prolog. The cube comes in by parameter and the source view is created in the prolog and deleted in the epilog...

Hello everybody, in our system we give users the possibility to work with sandboxes. My questions are: What am I able to monitor concerning sandboxes as administrator? I am especially interested in who is using how many sandboxes and their memory usage. This is also, because I have no idea if my con...