Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cognos promp dates

Posted on 2014-01-01
3
Medium Priority
?
284 Views
Last Modified: 2014-01-31
Hi,

I developing a report which requires to read from balance table it gives yesterday value which is fine, but I want also to read balance one day before.

what is the expression to use? or is there any other way or shortcut?

Thank you.
0
Comment
Question by:amq10
  • 2
3 Comments
 
LVL 12

Expert Comment

by:Habib Pourfard
ID: 39750164
we need more details. please let us know about the query you are using.
0
 

Accepted Solution

by:
amq10 earned 0 total points
ID: 39751187
thank you Pourfard.

the query I want to run is like this as I drag from package data items:

customer number
customer name
account balance amount  ( I expect output to show balance as yesterday which is fine)
account balance amount  -1 Day ( not included package data items).

I hope this can help.
0
 

Author Closing Comment

by:amq10
ID: 39823520
it works with some tricks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to increase the row limit in Jasper Server.
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Loops Section Overview
Suggested Courses
Course of the Month10 days, 14 hours left to enroll

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question