Then write like below.
"DIM_DATE"."DTD_GID" = "FCT_USERS"."CUS_DATE_VALID_FROM_"
if you don't want to change original conditions, then write it in sub query.
Definitely I don't want to change oryginal conditions.
Can you explain me where should I put this condition? How to do subquery?
Provide your query first, then will help you
Let me clear if I'm wrong with your requirment, or else you can follow the below solution.
1. Create a presentation variable on StartDate, say START_DATE.
2. Put an extra filter to your report from TimeDim table, Year IS PROMPTED.
Hope this helps..
How to create variable on presentation? Via Manage>variables>new>repository>variable ? Because I want to have in BI admin tool.
That's my measure:
Filter("base"."FCT_USERS"."distinct for new cusotmers" Using "base"."FCT_USERS"."USER_ACTIVE" = 1 )
it means I prefer to create entire measure in bi admin tool, so not to do anything in web-obi
Ohkey.!! Can you tell me which version are you using? If 22.214.171.124.0, then you can "Save columns to the Oracle BI Presentation Catalog for reuse in other analyses."
Let me know if this can help or else you need to de-continue your rule - "Not to do anything in web-obi"