Solved

Cognos promp dates

Posted on 2014-01-01
3
279 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

636 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