| A | B | |
|---|---|---|
1 | ||
2 | ::tm1env | TeamOneTest |
3 | # connection saved as private | |
4 | -host | ibmpa.succeedium.com |
5 | -securitySheet | USERS |
6 | -startRow | 1 |
7 | -startColumn | 3 |
8 | ||
9 | ::tm1env | TeamOneProd |
10 | # connection saved as private | |
11 | ||
12 | ::tm1env | IBM PA Cloud |
13 | # check your IBM Planning Analytics Welcome Kit | |
14 | -host | Your_PA_Server.planning-analytics.ibmcloud.com |
15 | -server | YourTm1DatabaseName |
16 | -namespace | LDAP |
17 | # Generate secret for your non-interactive user account | |
18 | -secret | |
19 | ||
20 | ::tm1process | Sample tm1process task |
21 | -name | copy_version |
22 | -info | Run copy_version process |
23 | pCubeName | Revenue |
24 | pYear | 2026 |
25 | pFromVersion | Budget |
26 | pToVersion | Budget 2 |
27 | ||
28 | ::tm1data | tm1data VIEW |
29 | -sheet | tm1data |
30 | -info | Fetch data from an existing cube view |
31 | -activate | TRUE |
32 | -cube | Job Type Assumption |
33 | -view | All |
34 | ||
35 | ::tm1data | tm1data MDX |
36 | -sheet | tm1data |
37 | -info | Fetch data using MDX |
38 | -activate | TRUE |
39 | # Calculate Year | 2026 |
40 | -mdx | SELECT NON EMPTY {TM1FILTERBYLEVEL( {TM1SUBSETALL( [JobType] )}, 0)} DIMENSION PROPERTIES [JobType].[Caption_Default] ON AXIS(0) FROM [Job Type Assumption] WHERE ([Year].[2026] ), [Version].[Budget] |
41 | ||
42 | ::tm1data | tm1data |
43 | -sheet | tm1data |
44 | -info | Fetch data for the specified elements |
45 | -activate | TRUE |
46 | -cube | Job Type Assumption |
47 | -startRow | 1 |
48 | -startColumn | 1 |
49 | Year | /Y*/ |
50 | Version | Actual; Budget |
51 | JobType | A |
52 | JobTypeAssumption | $LEAVES |
53 | ||
54 | ::tm1import | Sample TM1 data import task |
55 | -info | Import tm1data sheet data |
56 | -cube | Job Type Assumption |
57 | -sheet | tm1data |
58 | -startRow | 1 |
59 | -startColumn | 1 |
60 | -skipBlank | TRUE |
61 | -checkIfUpdatable | TRUE |
62 | ||
63 | ::tm1fileoutput | Sample tm1fileoutput task |
64 | -info | Output data to Job Type Assumption (export).txt |
65 | -sheet | tm1data |
66 | -cube | Job Type Assumption |
67 | -startRow | 1 |
68 | -startColumn | 1 |
69 | -file | ..\Job Type Assumption (export).txt |
70 | -delimiter | , |
71 | ::tm1data | Sample tm1data |
72 | -sheet | tm1datacompare |
73 | -info | Fetch data for the specified elements |
74 | -activate | TRUE |
75 | -cube | Revenue |
76 | Year | /Y?/ |
77 | Version | Actual; Budget |
78 | Revenue | Gross revenue |
79 | ||
80 | ::tm1datacompare | Sample tm1datacompare |
81 | -info | Compare tm1data Test vs Prod |
82 | -tm1data | Sample tm1data |
83 | -tm1env | TeamOneProd |
84 | -activate | TRUE |
85 | ||
86 | ::sheet.snapshot | Snapshot reports |
87 | -info | Create static copies |
88 | Exploration | |
89 | Dashboard | |
90 | Sheet3 | |
91 | ||
92 | ::sheet.truncate | Clear upload forms |
93 | -info | Truncate upload templates |
94 | -keepRows | 4 |
95 | -addRows | 100 |
96 | Forecast upload | |
97 | Sheet2 | |
98 | ||
99 | ::task.group | Prepare forecast upload |
100 | -info | Clear cube data and prepare upload forms |