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

    QUERY Timeout Problem

    I have the below code in one of my ASP.NET pages. The ConnectionTimeout is not working I am getting an error after just 15 sec. Can some one suggest me the correct code. ******************************************************** Dim ConnectionString As String =...
  2. banda27

    Problem in creating Metrics based on a Metrics

    1) No, the manuals for 7.2.1 & 7.2.2 are different. 7.2.1 does not have CASE functionality. 2) Even after building the Metrics as compound metrics, the SQL generated is same nested.... Any way, Thank you for your help.
  3. banda27

    Problem in creating Metrics based on a Metrics

    Thank you chael & entaroadun for your help. I have few more questions entaroadun. 1) We have MS 7.2.1. Can you please tell me where or in which manual the CASE functionality is explained? 2) How can I do separate passes for each calc? Thanks You Sri
  4. banda27

    Problem in creating Metrics based on a Metrics

    Hi All, I have a report in which few metrics are calculated using other metrics in the report. These metrics are created using ApplySimpe and CASE statements. The problem is the SQL generated is very complicated and it is bigger that 64kb. Eg: SELECT (des_amt * 20) as a ,(CASE...
  5. banda27

    Calculate Metric Based on Prompt result.

    I have a Prompt with two options '0' or '1'. I have a metric with a formula. This formula needs to be changed according to the result of the Prompt. I mean change of formula means calculating the metrics with different facts. Can someone suggest me a solution. Thanks for your help.

Part and Inventory Search

Back
Top