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,

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

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.

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?

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.

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.

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)

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??

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');

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.

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 :'(

When you hard coded the value did the report run without an error?

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