I create 2 query objects (ie. Query1 and Query2). Now I would like to join the 2 queries. How do I do that?
Each of the Query objects contain a tabluar model under them.
Below is the format of the report I need to develop:
Product Year Season Week1 Week2 Week3 Week12
to date to date sales sales sales ....sales
Sales sales
------- ------- ------- ----- ----- ----- -----
Using report net I created this report...
I have a report developed in report Net that is taking too long to run.
1. Will building a cube help speed this up?
2. Is there a way to rebuild the cube from the command line? I ask this question because I want to be able to schedule the rebuilding/refreshing of this cube based on the...
I'm trying to set a filter where the calander_date column is greater than equal to the minimum of 2 given dates. THis is what my expression looks like:
[Business Layer].[DATE_INFO].[CALENDAR_DATE] >= minimum(to_date('31-jul-2004'), to_date('30-may-2005'))
when I try to validate this function...
I'm using report net and would like to filter a simple report based on the time dimention to display all year to date sales.
My filter in SQL language will read:
where fiscal_year = (select fiscal_year from date_info
where calendar_date = trunc(sysdate))
a) I'm not sure...
I'm using report studio to generate a report that has teh following columns:
'product' 'YTD sales' 'QTD sales' 'Last years sales'
--------- ----------- ----------- ------------------
columns 2,3 and 4 query the sales fact table over a different time frame (YTD-year to date, QTD...
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.