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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. unarayan

    Union with SQL

    Awesome, that worked the way I wanted it to. Now can you elaborate more on formatting. I sure my master query and detail query will always have a one to one relationship and I want it to look like a simple list query, can you tell me how to do this. I'm not sure I understand you when you say...
  2. unarayan

    Union with SQL

    I have a very simmilar situation. I created 2 query objects (ie query 1 and query 2) both contain a tabular object. Now I need to join both the query ojects based on a common field how do I do that?
  3. 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.
  4. unarayan

    can cubes be rebuilt using command line commands.

    Because the report needs to be scheduled based on the completion of other events which Appworx is currently scheduling.
  5. unarayan

    can cubes be rebuilt using command line commands.

    Thank, can you also tell me weather I can run a report-net report from the command-line. We use a scheduler called appworx and I'd really like to schedule a report-net report using the same tool rather than Cognos's scheduler. Will I need to install Cognos's SDK for this purpose?
  6. unarayan

    can cubes be rebuilt using command line commands.

    Do I need the SDK installed to use this feture. Thanks for all your help. I'll try that and get back.
  7. 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...
  8. 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...
  9. 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...
  10. unarayan

    precompute parameters/variables whit sub query values

    That will not work our fiscal calander is different from the regular calander. eg. of date_info table's data calander_date Fiscal_year ------------- ----------- 30-aug-04 2004 31-aug-04 2005 28-sep-04 2005 04-may-05 2005 29-Jul-05 2005 20-Jul-05...
  11. unarayan

    precompute parameters/variables whit sub query values

    I did try that, but what I'm trying to do is avoid the user intervention to select the current fiscal year, when it can be automatically calculated based on system date. I think my next step is going to be to add a function in oracle called get_current_fiscal_year with the following SQL ...
  12. unarayan

    different columns of my report needs a different filter condition

    roberda, I still have not had any sucess with DoubleD's suggestion....but I got sidetracked and have not tried hard enough. Umag I liked your suggestion of creating multiple list queries for each data and show them side by side. Can you give me details on how to go about this. How do you create...
  13. 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...
  14. unarayan

    different columns of my report needs a different filter condition

    Awsome approch....thank you. I'll try that.
  15. 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