Hello,
My feedback:
1. Or you can use FTP tools, in particular, FileZilla. However, with such FTP tools, you first copy all needed files from the source environment to your own PC. Then copy all files from your PC to the target environment. It takes time if you are talking about many files (many GB). We will have to see what is quicker for instance: delete a folder with 10s of thousands of files through FileZilla (FTP) or through PAW. I hope that the speed in PAW is on par with what we had in the rich tier, which is much faster than deleting many files through FileZilla (It's much more a one by one kind of file removal I have the impression and for large numbers of files this can take long).
3. Even without exporting cube data to text files: you can create a TI process that extracts the required files from an earlier backup. 7zip can do that. For instance, specify a cube name and the process extracts from the provided backup file the cub file, (for example) 8 dim files and a few others for hierarchies, the rux file if there is one, the views on the cube (if applicable and wanted), the subsets on the dimensions and hierarchies, files for attributes, etc. That should run relatively quickly but a TI process that is not straightforward to write. TM1 experience is required for such task. But once the TI has run, you can move the files over and maybe delete a couple that you don't need but which were extracted anyway.
Caveat: 7zip and hence ExecuteCommand is used, so a no-go in version V12. Also, files as such, a no-go in V12. So it's not the solution that you will use for many years to come. And in PAoC, no rich tier, so testing your script is not possible in for instance PowerShell ISE. You would have to set it up in a different environment were it can be tested properly, then migrate to PAoC. PAW and FileZilla still allow the upload of exe files, PowerShell files, etc but the testing is not (easily) done anymore without the RDP solution.
4. PowerShell can be run from PAoC, no issue. Typically for 2 things: backups and emails. You can set it up with the above caveats in mind. In V12 it will be TM1 REST API calls and JSON type of payloads.
Best regards,
Wim Gielis
------------------------------
Wim Gielis
------------------------------
Original Message:
Sent: Wed July 31, 2024 03:04 PM
From: Vlad Didenko
Subject: Rich Tier Removal
1.How to migrate required(few) objects one environment to another environment in the PAW ?
If you're referring to the TM1 server objects (and not the PAW content), you can utilize the File Manager, but it will involve additional steps to copy the files to/from the model_upload folder. If you're open to paid solutions, you can use SPACE TM1 Lifecycle Manager to compare and move objects and data between TM1 servers directly in PAW with just one click:
3.Daily Data backup using TI process and restore the data with required objects only?
You can create custom TI processes to export the required cube data to text files or import it back. Using process parameters, you can control the logic of what to export or import. SPACE also has backup capabilities too.
4. How can proceed Email attachment using powershell script?
I don't know if it is possible to use a Powershell script on PAoC, but SPACE has an email service that can be pointed to your SMTP server, and you can call it from TI processes to send emails with attachments.
5.To view the data using required Elements paste directly in the architect dimension , Is this option available in PAW?
If you are referring to copying and pasting elements in the subset editor, then the answer is yes, you can do that in PAW.
------------------------------
Vlad Didenko
Founder at Succeedium
TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
https://succeedium.com/teamone/
Succeedium Planning Analytics Cloud Extension
https://succeedium.com/space/
Original Message:
Sent: Mon July 29, 2024 12:41 PM
From: Prasanna Bandi
Subject: Rich Tier Removal
Rich tier removal ,Please help here.
1.How to migrate required(few) objects one environment to another environment in the PAW ?
2.Data upload using perspective?
3.Daily Data backup using TI process and restore the data with required objects only?
4.How can proceed Email attachment using powershell script?
5.To view the data using required Elements paste directly in the architect dimension , Is this option available in PAW?
Thanks
Prasanna
------------------------------
Prasanna Bandi
------------------------------