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

    Report Cache not being used

    How can you tell if the report cache is being used when you run a report in the Web interface? I have executed several reports in Desktop, and when I re-execute the reports in Desktop, the reports come back instantaneously. When I run the same reports in the Web interface, it seems that the...
  2. cheesyman5k

    Dimesional Metric Issue (not grouping in SQL)

    I have two Attributes Parent and Child (Parent has many Children) I have a metric called COST which is defined as max(Cost) at the Child level I have another metric called visits which is a count of records the a Child has in the visits table. Lastly I have a compound metric called REV which is...
  3. cheesyman5k

    extracting part of a column value

    I have a string with pipes as in the following that I need to extract multiple pieces of data from. 12345|1600 Pennsylvania|09999|01876|2125559999 it contains an id, address, second id, zipcode and lastly telephone number but sometimes the value is like this '|||01876|2125559999' and i...
  4. cheesyman5k

    MSTR Admin question RE number or connections per User

    How many connections to MSTR Web can be open for a given user at the same time? Thanks in advance, cheese
  5. cheesyman5k

    Another Substr / Instr question

    hello all, can you help me create the correct substring or intstring statement to return everything after the second to last underscore of a column value? for example: column value = 'cheesy_man_5000' return value should be 'man_5000' column value = 'tek_tips_is_the_best' return value should...
  6. cheesyman5k

    substr and or instr

    hello all, can you help me create the correct substring or intstring statement to return everything after the last underscore of a column value? for example: column value = 'cheesy_man_5000' return value should be '5000' column value = 'tek_tips_is_the_best' return value should be 'best' I...

Part and Inventory Search

Back
Top