Sample Models .................................336
Sample PowerCubes ...............................336
Sample Data Sources ...............................337
Appendix E. Guidelines for Working with SAP BW Data for Use in Transformer ....339
Working with SAP BW Data Using a Package in Framework Manager ...............339
Creating a BW Query in SAP Business Explorer Query Designer ................340
Creating a Package in Framework Manager .......................343
Creating a Model in Cognos Transformer ........................347
Working with SAP BW Data Using Externalized CSV Files in Framework Manager ...........349
SAP BW Query Requirements ............................351
Framework Manager Considerations .........................352
Building PowerCubes from SAP BW Data ........................353
Appendix F. IBM Cognos Transformer Expression Editor..............355
Building Expressions ................................356
Building an If-Then-Else Calculated Expression ......................357
Functions....................................357
Date Functions .................................358
Numeric Functions ...............................362
Text Functions .................................367
Aggregate Functions ...............................371
Constants ...................................373
Operators ...................................374
Mathematical, Logical, and String Operators .......................374
Comparison Operators ..............................375
Notices ...................................377
Glossary ..................................381
A......................................381
C......................................381
D......................................381
F......................................381
G......................................382
H......................................382
I.......................................382
L......................................382
M......................................382
N......................................382
P......................................382
Q......................................383
U......................................383
Index ....................................385
xii
IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General