Search results for query: *

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

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

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

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

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

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

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 '='...

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

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.

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

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

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

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

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

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.

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

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