Hi,
I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
Answer Posted / kumar
Hi Friends,
in Prompt page add a filter like
Treat Ship Date as a Date Column,
ANS: day_of_week(Ship Date,0) not in (5,6)
Here 0-Monday
1- Tues Day
..................
Thank You
Kumar
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Name the types of gateway?
What are the themes in a data warehouse?
Why cognos decision stream is used?
What is the difference between static and dynamic conditions?
What is difference between informatica power mart and power center?
What DB View and Bus View?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What are the methods by which it non-durable model could be changed into the durable model?
Can you define drill across?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What are the components of the report studio?
What are the ways to import data into catalog?
How to apply securities for reports in cognos connection?
What is metric store database?
What is cognos connection?