Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] GLOBAL VARIABLE IN FILTER AFTER HOLDS AND JOIND IN INFOASSIST

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] GLOBAL VARIABLE IN FILTER AFTER HOLDS AND JOIND IN INFOASSIST
 Login/Join
 
Platinum Member
posted
Hi,
after using InfoAssist, I want to filter the date with a global variable.


-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+CjwhLS0xLjAtLT48Um9vdCB2ZXJzaW9uPSIxLjEiPgogICAgPE9iamVjdCBvYmplY3RJZD0iVGFibGVfMSI+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjEwPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsT3B0aW1pemF0aW9uIiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+CiAgICA8L09iamVjdD4KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IlRhYmxlXzIiPgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIvPgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJTYW1wbGVEYXRhIiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xMDwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbE9wdGltaXphdGlvbiIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5PgogICAgPC9PYmplY3Q+CiAgICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV8zIj4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iTGlua2VkU29ydHMiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2FtcGxlRGF0YSIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+MTA8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxPcHRpbWl6YXRpb24iIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4KICAgIDwvT2JqZWN0PgogICAgPE9iamVjdCBvYmplY3RJZD0iVGFibGVfNCI+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImN1c3RvbVdoZXJlcyIgdHlwZT0iTWFwIj4KICAgICAgICAgICAgPEVudHJ5IGtleT0iMCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+REFURURJRihBUlNfUkVQT1JUSU5HLktFTk5aQUhMRU5fQVNTRVRfTElTVEUuREFUVU0sICZhbXA7YXBvczsmYW1wO2FtcDtZWU1EJmFtcDthcG9zOywgJmFtcDthcG9zO0QmYW1wO2Fwb3M7KSBMRSA3X1dIRVJFX1NFUEFSQVRPUl9mYWxzZTwvRW50cnk+CiAgICAgICAgPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2FtcGxlRGF0YSIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+MTA8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxPcHRpbWl6YXRpb24iIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4KICAgIDwvT2JqZWN0PgogICAgPE9iamVjdCBvYmplY3RJZD0iVGFibGVfNSI+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjEwPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsT3B0aW1pemF0aW9uIiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+CiAgICA8L09iamVjdD4KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IlRhYmxlXzYiPgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIvPgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjdXN0b21XaGVyZXMiIHR5cGU9Ik1hcCIvPgogICAgPC9PYmplY3Q+CiAgICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiPgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJTYW1wbGVEYXRhIiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xMDwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJ1blJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4wPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsT3B0aW1pemF0aW9uIiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmxhYmVsPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0icHJlZml4RGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iQWN0aXZlX1N0eWxlX1VzZXJfdHlwZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+cG93ZXI8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0
*-INTERNAL_COMMENT LINE#1$cmluZyI+bm90IGluaXRpYWxpemVkPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2F2ZVN0YXJ0VG9vbEluVHlwZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UmVwb3J0PC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsVmFsdWVzUGFnaW5nIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj40PC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiPgogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkVkaXRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJhdXRvRHJpbGxTY3JpcHQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4KICAgICAgICAgICAgPEVudHJ5IGtleT0icnVuT25TdGFydHVwRGVmZXJyZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9Im1ldGFkYXRhX3ZpZXdzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheURhdGFUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjU8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW5zZXJ0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9InJ1bk9uU3RhcnR1cEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUludGVyYWN0aXZlTW9kZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXRfbGF5b3V0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVF1aWNrQWNjZXNzVG9vbGJhclNhdmVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9jb21wb3NlX2Zvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UERGPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVJlc291cmNlc0ZpZWxkVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlGb3JtYXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5PgogICAgICAgIDwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImNhc2NhZGVOYW1lcyIgdHlwZT0iTWFwIi8+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ik1hc3Rlcl9GaWxlcyIgdHlwZT0iU2V0Ij4KICAgICAgICAgICAgPEVudHJ5IHR5cGU9ImphdmEubGFuZy5TdHJpbmciPkthcEJldFF1b3RlbkFsbGU8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+YXJzL2Fyc19yZXBvcnRpbmc8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+Z3J1bmRtZW5nZV9iZXN0YWVuZGU8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+Z3J1bmRtZW5nZV9kYWNoZm9uZHM8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+YmVzdGFlbmRlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmVpZ2VuYmVyZWNobnVuZ19rYXBiZXRxdW90PC9FbnRyeT4KICAgICAgICA8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJtZXRhZGF0YVZpZXdBcyIgdHlwZT0iTWFwIj4KICAgICAgICAgICAgPEVudHJ5IGtleT0iYXJzL2Fyc19yZXBvcnRpbmciIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPk1ldGFEYXRhVHJlZS5WSUVXX0RJTVM8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJH
*-INTERNAL_COMMENT LINE#2$UlVORE1FTkdFX0RBQ0hGT05EUyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TWV0YURhdGFUcmVlLlZJRVdfVFJFRTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9IkJFU1RBRU5ERSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TWV0YURhdGFUcmVlLlZJRVdfVFJFRTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImJlc3RhZW5kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TWV0YURhdGFUcmVlLlZJRVdfVFJFRTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9IkdSVU5ETUVOR0VfQkVTVEFFTkRFIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19UUkVFPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iS0FQQkVUUVVPVEVOQUxMRSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TWV0YURhdGFUcmVlLlZJRVdfVFJFRTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9IkVJR0VOQkVSRUNITlVOR19LQVBCRVRRVU9UIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19UUkVFPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZWlnZW5iZXJlY2hudW5nX2thcGJldHF1b3QiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPk1ldGFEYXRhVHJlZS5WSUVXX1RSRUU8L0VudHJ5PgogICAgICAgIDwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNsaWNlckd1aUlzbGFuZCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZXlKaVFYVjBiMUJ5WlhacFpYY2lPbVpoYkhObExDSmlUM0IwYVc5dWMwZHliM1Z3Vm1semFXSnNaU0k2ZEhKMVpTd2lZbEpsWTB4cGJXbDBSM0p2ZFhCV2FYTnBZbXhsSWpwMGNuVmxMQ0ppVUhKbGRtbGxkME52Ym5SeWIyeFdhWE5wWW14bElqcDBjblZsTENKaVVuVnVkR2x0WlVOdmJuUnliMnhXYVhOcFlteGxJanAwY25WbGZRPT08L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJTTElDRVJfSU5GT1JNQVRJT04iIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPlBEOTRiV3dnZG1WeWMybHZiajBpTVM0d0lpQmxibU52WkdsdVp6MGlWVlJHTFRnaUlITjBZVzVrWVd4dmJtVTlJbTV2SWo4K1BDRXRMVU5QVFZCTVJWUkZYMU5NU1VORlVsOUhVazlWVUMwdFBqeFRURWxEUlZKZlIxSlBWVkErUEVkU1QxVlFJR2R5YjNWd1RuVnRZbVZ5UFNJd0lpQnpiR2xqWlhKSGNtOTFjRXhoWW1Wc1BTSkhjbTkxY0NBeElpQnpiR2xqWlhKSGNtOTFjRTl5WkdWeVBTSXdJaUJ6YkdsalpYSkhjbTkxY0ZOcGVtVTlJakFpSUhOc2FXTmxja2R5YjNWd2FHbGtaVDBpWm1Gc2MyVWlMejQ4TDFOTVNVTkZVbDlIVWs5VlVEND08L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+ZmFsc2U8L1Byb3BlcnR5PgogICAgPC9PYmplY3Q+CjwvUm9vdD4K
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON

*-HOLD_SOURCE
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ars/ars_reporting
BY ARS_REPORTING.ASSET.ASSETID
WHERE ARS_REPORTING.ASSET.ASSET_CODE EQ 'LU0203223739' OR 'LU0185901153' OR 'LU0124664391';
ON TABLE HOLD AS grundmenge_dachfonds FORMAT SQL_SCRIPT
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET GRWIDTH 1
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/wertpapiere_ars_bereich/Design/DekaInvestment_V1.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, PAGESIZE=A4, HFREEZE=OFF, $
ENDSTYLE
END
-RUN
*-HOLD_SOURCE
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ars/ars_reporting
BY ARS_REPORTING.BESTAND.DATUM
BY ARS_REPORTING.ASSET.ASSETID AS ('DACHFONDS_ID', ARS_REPORTING.ASSET.ASSETID, 'DACHFONDS_ID' )
BY ARS_REPORTING.BESTAND.ASSETID AS ('BESTAND_ID', ARS_REPORTING.BESTAND.ASSETID, 'BESTAND_ID' )
BY ARS_REPORTING.BESTAND.DF_BESTAND_ANTEIL
BY ARS_REPORTING.BESTAND_EIGENSCHAFTEN.DF_BESTAND_WPTKLASSE
BY ARS_REPORTING.BESTAND_EIGENSCHAFTEN.DF_BESTAND_WPTINST
BY ARS_REPORTING.BESTAND_EIGENSCHAFTEN.ASSETTYPKENNZEICHEN
WHERE DB_INFILE('grundmenge_dachfonds',ARS_REPORTING.ASSET.ASSETID,GRUNDMENGE_DACHFONDS.GRUNDMENGE_DACHFONDS.ASSETID);
WHERE ARS_REPORTING.BESTAND_FILTER.F_STICHTAG_BESTAND_LETZTER_HT ;
WHERE ARS_REPORTING.BESTAND_EIGENSCHAFTEN.ASSETTYPKENNZEICHEN EQ 'W' OR 'F';
WHERE ARS_REPORTING.BESTAND_EIGENSCHAFTEN.DF_BESTAND_WPTKLASSE EQ 'Aktie' OR ARS_REPORTING.BESTAND_EIGENSCHAFTEN.ASSETTYPKENNZEICHEN NE 'W';
ON TABLE HOLD AS bestaende FORMAT BINARY
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/wertpapiere_ars_bereich/Design/DekaInvestment_V1.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, PAGESIZE=A4, HFREEZE=OFF, $
ENDSTYLE
END
-RUN
*-HOLD_SOURCE
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE bestaende
BY BESTAENDE.BESTAEND.BESTAND_ID
ON TABLE HOLD AS grundmenge_bestaende FORMAT BINARY
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/wertpapiere_ars_bereich/Design/DekaInvestment_V1.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, PAGESIZE=A4, HFREEZE=OFF, $
ENDSTYLE
END
-RUN
*-HOLD_SOURCE
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ars/ars_reporting
BY ARS_REPORTING.ASSET.ASSETID
BY ARS_REPORTING.KENNZAHLEN_ASSET_LISTE.DATUM
BY ARS_REPORTING.KENNZAHLEN_ASSET_LISTE.WERT
WHERE DATEDIF(ARS_REPORTING.KENNZAHLEN_ASSET_LISTE.DATUM, '&YYMD', 'D') LE 7;
WHERE DB_INFILE('grundmenge_dachfonds',ARS_REPORTING.ASSET.ASSETID,GRUNDMENGE_DACHFONDS.GRUNDMENGE_DACHFONDS.ASSETID) OR DB_INFILE('grundmenge_bestaende',ARS_REPORTING.ASSET.ASSETID,GRUNDMENGE_BESTAENDE.GRUNDMEN.BESTAND_ID);
WHERE ARS_REPORTING.FILTER_KENNZAHLENLISTE.F_KL_AKTUELLSTE_KENNZAHL ;
WHERE ARS_REPORTING.KENNZAHLEN_ASSET_LISTE.CODE_KENNZAHLTYP EQ 'KAPITALBET_QUOTE';
ON TABLE HOLD AS KapBetQuotenAlle FORMAT SQL_SCRIPT
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/wertpapiere_ars_bereich/Design/DekaInvestment_V1.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, PAGESIZE=A4, HFREEZE=OFF, $
ENDSTYLE
END
-RUN
*-HOLD_SOURCE
-*COMPONENT=Join_J001
JOIN BESTAENDE.BESTAEND.BESTAND_ID IN BESTAENDE
TO UNIQUE KAPBETQUOTENALLE.KAPBETQUOTENALLE.ASSETID IN KAPBETQUOTENALLE TAG J001 AS J001
END
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE bestaende
BY BESTAENDE.BESTAEND.DATUM
BY BESTAENDE.BESTAEND.DACHFONDS_ID
BY BESTAENDE.BESTAEND.BESTAND_ID
BY BESTAENDE.BESTAEND.DF_BESTAND_ANTEIL
BY BESTAENDE.BESTAEND.DF_BESTAND_WPTKLASSE
BY BESTAENDE.BESTAEND.DF_BESTAND_WPTINST
BY BESTAENDE.BESTAEND.ASSETTYPKENNZEICHEN
BY J001.KAPBETQUOTENALLE.WERT
ON TABLE HOLD AS eigenberechnung_kapbetquot FORMAT BINARY
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET GRWIDTH 1
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES MIXED
ON TABLE SET HOLDATTRS ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/wertpapiere_ars_bereich/Design/DekaInvestment_V1.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, PAGESIZE=A4, HFREEZE=OFF, $
ENDSTYLE
END
-RUN

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ars/ars_reporting
BY ARS_REPORTING.ASSET.ASSETID
BY ARS_REPORTING.WMX_EIGENSCHAFTEN_HIST.WMX_VALUE
WHERE ARS_REPORTING.WMX_EIGENSCHAFTEN_HIST.DATUM_WMX_EIG EQ &&LETZTER_ANALYSETAG;
WHERE ARS_REPORTING.WMX_EIGENSCHAFTEN_HIST.QUELLWERT EQ 'GD504K';
WHERE DB_INFILE('grundmenge_bestaende',ARS_REPORTING.ASSET.ASSETID,GRUNDMENGE_BESTAENDE.GRUNDMEN.BESTAND_ID) OR DB_INFILE('grundmenge_dachfonds',ARS_REPORTING.ASSET.ASSETID,GRUNDMENGE_DACHFONDS.GRUNDMENGE_DACHFONDS.ASSETID);
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/wertpapiere_ars_bereich/Design/DekaInvestment_V1.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, PAGESIZE=A4, HFREEZE=OFF, $
ENDSTYLE
END

-RUN

i can't put my global variable there, because I get an FOC236 error. Focal Point says that FOC236 is a JOIN Error. So I validated, that my join is correct. All the Hold files are printable.

Where is the Problem with my Filter ??

Hope you have some Ideas..
The Format of Filter and Value are the same.

Need to be solved with InfoAssist.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Report This Post
Virtuoso
posted Hide Post
I don't think that you have an error with your variable. As stated, your error is with the JOIN
quote:

All the Hold files are printable.

Not because you can print each files separately that joining them will work.

quote:

I get an FOC236 error. Focal Point says that FOC236 is a JOIN Error.


Meaning of FOC236:
(FOC236) LINKED FILE DOES NOT HAVE A MATCHING KEY FIELD OR SEGMENT: The referencing, and cross-referenced file do not have the field 
 named as the CRKEY in common. The CRKEY must be the fieldname or alias of the referencing field and the fieldname of the cross-referenced field. 

From what I can see you are trying to join field BESTAND_ID from BESTAENDE (which is a binary file) to ASSETID from KAPBETQUOTENALLE (which is a SQL_SCRIPT file...which is a sequential file).
But ASSETID doesn't seems to be INDEXED and it normally have to be if you want it to be joined to another file.

How To : SQL_SCRIPT


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Virtuoso
posted Hide Post
I doubt the variable is the problem, but as a test try either commenting out the WHERE test with the global variable or hard code the value to see if you still get the error. I'm pretty sure you will.

Like MartinY says, you are joining two tables with different formats. When you do that, you have to make sure you meet all the conditions necessary to get the join to work. Unless there's a compelling reason to keep these two tables in different formats, you should hold them in the same format (I'd go with FORMAT FOCUS INDEX ASSETID) and then test your join.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Platinum Member
posted Hide Post
Ok Thanks, very helpful.

But I can print my already joined Table, that's what i am wondering about... the field formats of assetid an bestaende are the same.
So there Need to be an index on the field i am joining?
Even if there are no dupicates for sure?


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Report This Post
Virtuoso
posted Hide Post
If both tables in the join are in a dbms, then that dbms will handle their index requirements. However, your table is a BINARY file which is basically a file on disk with no dbms to manage it. Consequently, you should consider either putting your hold files in a dbms like SQL Server or alternatively FOCUS. If you go with FOCUS, you need to have an index on the join fields, regardless of the uniqueness of the column values.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Virtuoso
posted Hide Post
quote:

But I can print my already joined Table, that's what i am wondering about


It may possibly just do a SQL equivalent as JOIN ALL but I'm surprise that
JOIN BESTAENDE.BESTAEND.BESTAND_ID IN BESTAENDE
TO UNIQUE KAPBETQUOTENALLE.KAPBETQUOTENALLE.ASSETID IN KAPBETQUOTENALLE TAG J001 AS J001
END
TABLE FILE bestaende
BY BESTAENDE.BESTAEND.DATUM
BY BESTAENDE.BESTAEND.DACHFONDS_ID
BY BESTAENDE.BESTAEND.BESTAND_ID
BY BESTAENDE.BESTAEND.DF_BESTAND_ANTEIL
BY BESTAENDE.BESTAEND.DF_BESTAND_WPTKLASSE
BY BESTAENDE.BESTAEND.DF_BESTAND_WPTINST
BY BESTAENDE.BESTAEND.ASSETTYPKENNZEICHEN
BY J001.KAPBETQUOTENALLE.WERT

display all the BY fields, especially the last one.

So there Need to be an index on the field i am joining? -- Yes
Even if there are no dupicates for sure? -- Yes.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Gold member
posted Hide Post
Hi Jenni

Probably the very first thing to do is rule out that && variable as the source of problems.

As Babak suggested, fill in that last analysis day && with a literal instead of using the global &&LETZTER_ANALYSETAG.

Check and see if your issue magically disappears.

My concern here is that you have -RUN after your JOIN statement, yet your complaint seems to come up at a different place. I'm wondering if WebFOCUS is attempting to use your WHERE statement as part of it's JOIN that it's trying to build, but maybe the && is not alive yet. (internally there is a step called WFDESCRIBE that might be getting confused).

So lets rule that out first so we know we are only talking about the JOIN statement as a problem.

After that we'll know what to talk about.

And just a note about indexing. I think your knowledge of a primary index in the database world might be confusing you here in this case. The other members here are pointing out that it's generally a good practice to use an Indexed field both for speed and accuracy to join TO. Thus the suggestion that a physical file on the disk might be good to use a format like FOCUS with an INDEX on the field you mean to JOIN to. Indexes in this case don't need to be unique (like a primary key might be).

We'll talk more about indexes and why you are using SQL_SCRIPT if we need to after you rule out the &&.

If I were running your case thats where I'd start.

Toby Mills
(former premium techsupport rep for IBI)
 
Posts: 62 | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
Hi,

I changed the hold Format into XFOCUS.

Still, I get the Problem when I fill my && Variable in.

I don't think there is a join Problem, because I get Output when I use a normal Date instead of the && Variable, even though I now that the Variable is correct..
By -type &&Variable I get what i am expecting...


Is there a Chance someone is able to correct my code??


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Report This Post
Virtuoso
posted Hide Post
We don't know what is the format of DATUM_WMX_EIG and what is passed in &&LETZTER_ANALYSETAG but I can suggest to try the following

WHERE ARS_REPORTING.WMX_EIGENSCHAFTEN_HIST.DATUM_WMX_EIG EQ &&LETZTER_ANALYSETAG.EVAL;

Or
WHERE ARS_REPORTING.WMX_EIGENSCHAFTEN_HIST.DATUM_WMX_EIG EQ '&&LETZTER_ANALYSETAG.EVAL';

Or
WHERE ARS_REPORTING.WMX_EIGENSCHAFTEN_HIST.DATUM_WMX_EIG EQ DT(&&LETZTER_ANALYSETAG);

Or
WHERE ARS_REPORTING.WMX_EIGENSCHAFTEN_HIST.DATUM_WMX_EIG EQ DT('&&LETZTER_ANALYSETAG.EVAL');


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Virtuoso
posted Hide Post
If you think the problem is with the variable you should consider our suggestion to test the WHERE test with a hard coded value to confirm this.

Another debugging technique to make sure your variable is correctly populated is to add

-SET &ECHO=All;

At the beginning of your code and look at the page source to see what the substitutions look like when WebFOCUS sees them. It'll give you a lot of insight into what's happening before WebFOCUS errors out.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Platinum Member
posted Hide Post
Thried all you suggestions @MartinY and @BabakNYC..
The Thing is, that Report was created by infoassist...
So actually there can't be a fault with the Join. I just Need to fix it :'(


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Report This Post
Virtuoso
posted Hide Post
When you hard coded the value did the report run without an error?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Virtuoso
posted Hide Post
quote:
I don't think there is a join Problem, because I get Output when I use a normal Date instead of the && Variable, even though I now that the Variable is correct..

Try using a local variable instead of a global one. Maybe the error reside there...

Local : &var
Global : &&var


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] GLOBAL VARIABLE IN FILTER AFTER HOLDS AND JOIND IN INFOASSIST

Copyright © 1996-2020 Information Builders