TM1 Forum

Thanks for the reply. I was afraid it would be something like this.

Hi am experimenting with newly implemented snippets in PAW and wondered if anyone knows where are the user-made custom snippets located? I tried the IBM documentation but found nothing in this regard. So far I failed to find them in file system and no luck in PAW interface either. Plus I noticed tha...

Thanks a lot, that was super helpful

Hello, the question of the day: Can you create a TI process in TI process? (inception sounds in the distance) I would love to create a process that creates a TI process that would load data from cube determined by parameter into cube determined by another parameter. I would name it a Loadator_L_800 ...

Thanks for your replies

Yes I intended to have subset with two names (aliases). It is not so much for organizational purposes as for user friendliness. We use prefixes in our subsets to indicate for what purpose the subset exists and for which cube, so there are subsets named: OO_AC_Sales_All_Leaves, OO_AC_Sales_Lev2_SORTE...

Hi, I was wondering and failing to find answer online: Can you assign alias to subset? I dont mean using aliases of the elements in subset, but giving the subset itself an alias. I am asking because the application we are developing is gaining on size and complexity. I would love to use some sort of...

Hi, vnValue is set as numeric in the datasource (viz first picture in original post). Some of the measure elements are string but they are filtered off from the sourceview.

Hi, I got stuck with this little problem and would appreciate any kind of help or advice. I am executing a subprocess through another process. The master process supplies the subprocess with parameters from data source (cube) variables. The subprocess then executes CellInctrementN function into diff...

Hi, I was wondering if it is possible to concatenate Element names and Attribute values using rules? Example: Concatenating.jpg I would like to get text value : "PF - Car Manufacturing" in the alias attribute Plny_nazev. I serached through the IBM documentation and oth this forum, but cant...

Sorry for forgetting to reply, your solution worked great, thanks

Problem solved. It is somewhat of a bug in PAW. Turns out if you manually create view in PAW (open the cube, manually change the dimension structure and save to the server) then the view is invisible for some functions and it is not even visible in architect. If you create the view with process or i...

Thore is a cell security (see emg), I am an admin and cant run it. The layout is 7 dimensions:

G_Dcerinne_Spolecnosti on Rows,
T_CasM - Columns
G_Druhy_Vozu
G_Temata
G_Zavod
V_Verze
M_Dcerine_SPolecnosti_Zasoby_IST

There are 3 dynamic subsets: G_Dcerinne_Spolecnosti, T_CasM, V_Verze

Hi, Yes I can open it, ViewExists returns 1

Hi, I am attempting to run simple TI process with ViewTitleElementSet. I created the view Default as seen in the pic, but when i try to run it I get an error msg: Error: Prolog procedure line (26): View "Default" in cube "<2>" not found. When I swith to Default1 it works fine. An...

Hi, I wondered if it is possible to identify column names in datasource with varible through which i could loop? I am uploading data from csv file. Rows - Accounts, Columns - Months (viz. picture) DataSource.png I cannot change the structure of the Data Source. I need to upload this data on the cube...

Thanks guys, I implemented some of your suggestions and client is happy with it

Thanks for the reply, It is however not quite what I was looking for. I need the user to be able to change the parameter - version with default version pre-selected. So if he runs the proces, he can either click ok(run) with pre-selected default version or change it.

Hi I was wondering if it is possible to set default parameter for action button starting a process based on subset. I have a process that selects a default version from dimension of all possible versions and stores it as a single element in a subset. I now need to have this default version as defaul...

Hi everyone, I am attempting to move data between Version dimension inside one cube with 3 dimensions: -V_Version (1-12), -T_Cas_M (Months: 1-12) and -M_Sales (Total_Sales, A_Sales, B_Salaes, Comment) Each Version contains data for specific month in dimension T_Cas_M. Version 1 contains data for mon...