-TIME-
PERIOD(START(Year))
PERIOD(END(Year))
-Dimension-
- default，all models include the Time and Versions dimensions.And List(Region\Brand etc.)
- How to map module:
.1 select the target line item as dimension for a new module
.2 base on the connection,selecting the conmon dimension as 'applies to' in the new module
.3 in the target module, use the function 'LOOKUP' to map the new module, so can connect source module. - How to apply list menber: FINDTEM(list_name, menber_name)
-conditional formating-
- add new line item to apply suitable number to every item
- base on the number, to format the target line item
-count-
- add new line item, and apply 1 to it
- use it for counting target calculation
-String Concatenation-
module.code to use: code_
code: code
Best Pratices：module.code to use & module.code
