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 TouchToneTommy 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: bridgeconsultant
- Content: Threads
- Order by date
-
Prompt within prompt question (3 prompts total)
Hello, I have a need to present to an end user in the web 3 prompts: Prompt 1: Supplier Category Prompt 2: Supplier name search(text value prompt - like % statement) wich only looks at suppliers from the supplier category chosen in prompt 1. Prompt 3: Shopping cart that allows you to...- bridgeconsultant
- Thread
- Replies: 3
- Forum: MicroStrategy, Inc. solutions
-
Multipass SQL with null date fields that need to be joined
MSTR 7.2.2 I have a report with a date attribute and four metrics. One of the metrics is dimensional metric that generated multipass SQL (really more like subqueries). When the passes are joined on the datefield, we lose records. Typically, in SQL, we do a coalesce. MSTR only does a coalese...- bridgeconsultant
- Thread
- Replies: 4
- Forum: MicroStrategy, Inc. solutions
-
Display initials in view...bad performance. Help needed
Hello, We're getting bad performance when attempting to only display user initials on a report (using a view). Any ideas on a better way of getting user initials? V2R5 SQL (FYI: if it was a null in the source, we put a '!' in the warehouse): SELECT (CASE WHEN T9.ContactFirstName <> '!'...- bridgeconsultant
- Thread
- Replies: 2
- Forum: NCR: Teradata
