on 05-27-2016 2:30 PM
Hi ,
In SAP BO 4.1 Web Intelligence Report , I want to make sysdate (current date) as a default value in Query filter with optional prompt . I don't want to add anything like filter or objects or parameters at the universe (IDT) level. Can anybody please provide your valuable suggestions .
Regards
Riya
I second what Mahboob is sayin. Best way to achieve this through Universe. Second option is to use a custom sql which I would not advise you to use. So I would say better explain this situation to your client. I am sure he would understan.
Also check out this thread as well hope this will clear your doubt on this issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Riya,
I don't know if there is a way to do it without creating a filter or object in the universe. Why don't you want to modify the Universe? If its a restriction issue to modify the Universe, then you should explain it better to people who're opposing it. Creating that filter or a Currentdate object in the Universe is one of the best practices, I'm sure many gurus agree with me.
How about updating the SQL generated by Universe? That sound's risky, isn't it? So, updating the Universe is the way to go.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I too agree with the point Mahboob mentioned it's always recommend to have this sort of situation at universe level in order to have your Universe scalable and flexible to handle multiple situations.
Also when you do such things all the processing is done before microcube is generated so better performance.
Regards
Niraj
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.