Atul,
This may be of some help to you.
There is a Tech note TN6200-751-1018 on a similar issue.
This is for 7.5.1 and above versions.
The "Waiting for autoprompt" status for that job goes away when the "Report Execution Time" has been exceeded. The Report Execution time is a project-level...
Hi Z3,
Can you tell me how to do the web customization to print the report run date on a report run and printed from web or post any customization code for the same if possible.
I need to display the report executed date and not the printed date.
Thanks!!
Nate/Phoenixer,
Thanks!! for your help.
Phoenixer, i got it working with Nates idea to creat transformation with year ,Qtr,Month in the transformation so it will be useful in drilling from year to qtr or month or various levels.
Nate- Thanks!again.
Nate,
Thanks for your responses.
Here is the SQL where i have the Qtr Attribute on the report with Rev. metric and a report filter Year between this year and last year.
In this it displays revenue values, but how do i get comparisons?
Here is the Description for Invoice_effective_Day_dim...
Nate,
This is the SQL for Year-Year,
I have used apply functions in the metric condition.
select nvl(a13.REVENUE_AREA_ID,999) REVENUE_AREA_ID,
a13.REVENUE_AREA_DESC REVENUE_AREA_DESC,
a11.NETWORK_KEY NETWORK_KEY,
a11.MARKET_KEY MARKET_KEY,
sum(a11.REVENUE) WJXBFS1
from...
Nate,
Thanks! for your response.
I see what you are saying, I tried that earlier.. i feel the M1, M2, M3 concept works fine only if it is like for Q101 - Q102 comparison but in my report i need
Q101 Q201 Varience Q201 Q202 Varience Q301 Q302 varience..
?
Appreciate your time to respond.
Happy New Year to All
Thanks! MSTRNate
Can you please elaborate me on filter creation to mimic the transformation?
I created dynamic filters and am able to display the Revenue for corresponding years and quarters, but not able to display the revenue Varation between Q101 - Q201 , Q102-Q202...
All,
I need to create a report for quarter to quarter data(revenue) comparison.
eg.
Qtr-> Q1-03 Q1-04 Q2-03 Q2-04 Q3-03 Q3-04
Product Revenue Variation
p1 $100 $125 ($25) $75 $57 ($18) $40 $50
P2 .....
Product/ year (quarter ) are attributes and...
I am not particular on using prompt. i need to get the Start Year and End Year from the user.
My idea was to create a prompt with two filters asking the user for choose the Start Year and again Choose the End YEar
If there is other ways to do it , that will be great.
Thanks,
All,
I have problem in formatting a Report Services Document to display an attribute as Column(e.g. Yearin PDF view.
Any help, ideas , tips greatly appreciated.
We are using MSTR7.5.1 version.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.