Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: unarayan
  • Content: Threads
  • Order by date
  1. unarayan

    Joining two queries

    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.
  2. unarayan

    Cros tab reports.

    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...
  3. unarayan

    can cubes be rebuilt using command line commands.

    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...
  4. unarayan

    filter with mininum function is not working

    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...
  5. unarayan

    precompute parameters/variables whit sub query values

    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...
  6. unarayan

    different columns of my report needs a different filter condition

    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...

Part and Inventory Search

Back
Top