My Top N Analyses &0T_CMONV& -
&0T_CMONB& (License Acquisition)
Technical name: 0IPM_C09_Q0002
Use
General Query for creating Top N analyses. The Top N values are determined based on the net value billed for the license sales contract (outgoing royalties).
This Query
is personalized (“My …”). It only displays data where the
Query user corresponds to the person responsible in the license acquisition
contract. The name of the user who is logged on is transferred for data
selection by means of the variable “User Name”
(0P_USER3).
This Query is used as the basis for
additional views (different views of the characteristics used) and Web
templates (for the use of these views).
Do not change the query, since doing so means that the views become inactive and web templates cannot be executed. If adjustments are required, we advise you to make changes to a copy of the query.
Views based on the query:
· 0IPM_C09_Q0002_V001 My Top N Acquisition Contracts
· 0IPM_C09_Q0002_V002 My Top N Licensors
· 0IPM_C09_Q0002_V003 My Top N IPs
· 0IPM_C09_Q0002_V004 My Top N Markets
· 0IPM_C09_Q0002_V005 My Top N Territories
· 0IPM_C09_Q0002_V006 My Top N Languages
Filters
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|
0CALMONTH |
Calendar year/month Restriction to: Variable 0CML12CM |
|
0IPM_PITMEX__0USER_NAME |
User name Restriction to: Variable 0P_USER3 |
Free Characteristics
|
InfoObject |
Description |
|
0IPM_LICNSR |
Licensor |
|
0IPM_POBJID |
License acquisition contract |
|
0IPM_PROD |
Intellectual Property: Distribution |
|
0IPM_RDIM01 |
Market |
|
0IPM_RDIM02 |
Territory |
|
0IPM_RDIM03 |
Language |
Variables Used
|
Variable |
Description |
|
0P_USER3 |
User name Usage: Personalize evaluation for the user who has logged on |
|
0CML12CM |
Last 12 months including current month |
|
0T_CMONV |
Text variable replaced by 0CALMONTH Use: To display the date interval from |
|
0T_CMONB |
Text variable replaced by 0CALMONTH Use: To display the date interval to |
Columns
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|
0IPM_ORNET |
Billed net value (outgoing royalties) Conditions: Top 5: Operator “Top N”, value “5”, status “active” |