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: *

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

    help with outer join

    I can't seem to get an outer join working the way I want. Given the following: 1) the 'sample_custs' view will return a sample of ~100 customer IDs. 2) the 'customer_computed_value' table will have all the customer IDs. 3) the 'order_basket' table will only have a subset of the customer IDs...
  2. JRO061601

    ReportNet CrossTab problem

    I'm trying to develop a report that has Months along the row headers and Categories along the column headers, with a single measure. I have an outer join in place so that a Month gets pulled onto the report, even if there are no records for that Month in any of the Categories. The report...
  3. JRO061601

    Can't sort RunningSum metric by Custom Group

    I keep running into the problem outlined in TN5700-72X-1001. I want to create reports using Custom Groups that show Cumulative Frequency (using the RunningSum function), but the metric is not calculated in the order of the Custom Group. Anyone else run into this and figure out a workaround...
  4. JRO061601

    Is this SQL possible?

    Can MSTR generate this? SELECT A.ATTRIBUTE, B.COUNT(PK) FROM LOOKUP_TBL A, FACT_TBL B WHERE A.PK=B.PK (+) GROUP BY A.ATTRIBUTE So I want to count rows in the fact table that aren't in the lookup table, group by a higher level attribute, and have the extra show up as a row with a NULL as the...
  5. JRO061601

    SELECT * in MSTR?

    Has anyone tried to generate a query in MSTR that does a SELECT *? I can only get so far, creating an attribute defined as - ApplySimple("*"). But when I put it in a query, MSTR thinks it's a column and aliases it as 'CustCol'. And the bigger question, even if we could generate the syntax...
  6. JRO061601

    Force Join on Count from Lookup Table

    I have a lookup table, CUST, with columns: CUST_ID HOUSEHOLD_ID I have two fact tables, OUTBOUND and RESPONSE, where CUST_ID is part of the primary key. I want to create a report that has two counts: 1) COUNT (DISTINCT A.HOUSEHOLD_ID) FROM CUST A, OUTBOUND B WHERE A.CUST_ID=B.CUST_ID...
  7. JRO061601

    WHERE clause use '=' instead of 'IN' ?

    If I define a prompt on an attribute ID:DESC, and set the min/max number of elements to 1, can I make the engine generate SQL using WHERE X = Y instead of using WHERE X IN (Y)? For that matter, if I create a static filter that only qualifies on one attribute element, can I force the use of '='...
  8. JRO061601

    Custom sub-query using ApplyComparison

    I'm trying to force MSTR to run a particular query that shows me a list of IDs that exist in a fact table but not in the lookup table. I defined the ID twice, allowing the form to only see it on either the fact or the lookup table. I used a custom expression filter using applycomparison...
  9. JRO061601

    Concat within COUNT function

    Is it possible to do a count distinct of a concatenation of two numeric columns in DB2? Something like this... COUNT(DISTINCT(NUMBER1 CONCAT NUMBER2)) If so, could you provide the syntax? Thanks.
  10. JRO061601

    Drill to Document & Dynamically Answer Prompt

    let's say i have report at the X level, and on the report is the attribute 'X ID #'. let's say i also have a document with 6 reports that all have the same prompt on them asking for a single 'X ID #'. i want a hyperlink on the regular report on 'X ID #', such that when it is clicked, it brings...
  11. JRO061601

    CG displaying Top N/Other for multiple time periods

    This might be a little convoluted. I need a report that shows top 5 states and other states by a simple metric by months. In the below case date is synonymous with month. I'm able to do this using two reports with a metric qualification filter on a metric built using the MSTR 'Rank' function...
  12. JRO061601

    AVG from a lower level ratio

    Can I make MSTR do this or something like it? select y.LOAD_DATE, avg(x.ratio) from ( select a.LOAD_DATE,b.PRS_LN_ID,(a.total_debt/b.ln_bpo_low_value) ratio from PRS_TBL_LN_PAYMENT a, PRS_TBL_LN_BPO_DETAILS b where a.PRS_LN_ID=b.PRS_LN_ID and a.LOAD_DATE=b.LOAD_DATE ) x, PRS_TBL_LOAD_PERIOD...
  13. JRO061601

    Custom Group Element Display

    I have a custom group with several elements defined. If one of the filter criteria doesn't return any records, that element isn't displayed on the report grid. I'd like for all the custom group elements to display, and if there are no records, display a zero in the metric column. Is there a...
  14. JRO061601

    Desktop Grid Takes Long Time to Render

    I have a report that executes in less than 1 second but takes almost 10 minutes to actually render the grid display on the Desktop. On top of that, I'm working in 3-tier mode, and I'm locked out of the Desktop while the report is rendering. 6,865 rows, 7 row attributes, 1 metric, and no column...
  15. JRO061601

    Filter on Selections Question

    If I have a Custom Group with more than one line item, should I be able to use the Filter on Selections option and limit the number of line items on a report? If not, then why do check boxes appear next to Custom Group line items when Filter on Selections is clicked on? Thanks.
  16. JRO061601

    Report Builder in Web

    When I use the Report Builder in Desktop, the prompts take me directly to a list of attributes and metrics. When I use the Report Builder in Web (as a Web Analyst), I am forced to drill from Schema Objects > Attributes and from Public Objects > Metrics. Why is this, and is there a way for the...
  17. JRO061601

    Passing Filter to Sub-Query

    Hi all, I'm building a report in which one of the columns has a filter built off it that gets a list from a sub-query. However, I need to put two additional filters on the report that get defined at run-time by the end user. My problem is that the filter criteria selected at run-time does not...

Part and Inventory Search

Back
Top