Name of predefined Filter: KeyDate
Where Clause : <filter key="[0P_ECKDT]"><condition key="[0P_ECKDT]" operatorcondition="Equal" tech_name="@Prompt('Key Date','D',,,)"/><CONDITION></FILTER>
Note : [0P_ECKDT] is the technical name of key date object in SAP BW for key date
2. Check the option “Use filter as mandatory in query -> Apply on Universe” so that key date should be asked every time user executes the query.
3. In Universe Parameters , set the “KEYDATE_ENABLED” to “No”, as shown in below image
Now the keydate will appear as normal prompt in webI documents and you can use them in xcelsius by using prompt binding.
Hi, I am facing the same issue & try to work around your solution but some how this Universe filter is not being parsed correctly and hence on report level it again through some error.
ReplyDeleteThe error I received at Universe level is mentioning something related to [0P_ECKDT]....
Any words over this ?
For your example must [OP_ECKDT] be visible in the universe? I can not seem to get this to work with my key date object. Also, must the query Key Date be set to optional instead of manditory for this to work?
ReplyDeleteI had implemented this solution for Xcelsius dashboards, because Key Date was being prompted in webi but in xcelsius there was no object to control this. About the SAP BI Side, I am not sure what BI people had done.
ReplyDelete