Search results for query: *

The query runs fine and I get data. I am stuck on this one specific piece syntax-wise: WHERE (CASE WHEN {?SOURCE} =1 THEN SOURCE='BRANCH' ELSE Y.SOURCE<> '' END) AND ..... I want to have the user select if they want to see 'branch data only' or 'all sources' (which would need to...

I cant seem to get this to work correctly. I am using an oracle backend and the code will be tossed into a Crystal command when done. Can someone point me in the right direction please? My code is as follows: SELECT (SELECT MAX(K0.TRANSACTION_DATE) FROM...

They're physically in the same location, so 'distance' shouldnt be a huge challenge. The golden rule on B is that data is one day old. Data updates occur at night while A (production) is relatively quiet. All transformations are using A data and writing to B2. The issue really popped in my...

First off, let me be very clear: I am working with a new dataset and am trying to understand why something 'is' the way it IS...and our DBA team is not too keen on answering questions of this nature. Background: Source environment (A) DW environment (B) - data direct from A (B1) and...

1. I cannot get my hands on the explain plan - all I have to work with is the following from the dba: " I ran explain plans on both versions (without the sums/with the sums), and neither had any full table scans - indexes were being used for every single table reference." 2. The performance...

The DBA ran the query this am under her rights and said that the query is NOT doing a full table scan. She says theres just something wrong with my query, too much going on in it. I'm stuck. Ideas?

FYI: Trying to see the explain plan shows that I have insufficient privs on underlying objects in the view.

I am really puzzled because the first SUM being done works, but adding any additional ones makes it impossible. I can execute the query in TOAD but cannot see the explain plan. I'm being told it is my query, not the db. GRR!!! Any other ideas on how to get around it?

I have a huge query and it runs in about 30 seconds UNTIL I add in ANY additional SUMs in the SELECT statement. Can somebody please explain to me what I am doing wrong that is causing this to occur? SELECT SOURCE, SR_RCL, SR_RCL_GRP, RCL_TEAM_LEAD_GRP, COUNT(APPLICATION_NBR) AS APPS...

BO XI r2.

Does anybody have a fresh, clean list of known BO WebI issues?

We'd like to be able to search for data elements across multiple universes at a time instead of having to open each one and do a separate search to find things. Is this possible?

NOTE: Of course, after posting I found a way to fix my problem and am posting it here for sharing. The way to get rid of the hyphen at the end of the string is by manipulating the second PATINDEX, like so: PatIndex('%[^0-9.]%' The full statement is shown below. Select appnumber, TB24...

I found the link and it's GREAT, but I have a spin for ya: I copied and pasted it and it worked great, with one exception: when there is a hyphen at the end of the string it is not removing it. Here is what I used for the SQL: Select appnumber, TB24, len(tb24) as lenTB24...

I'm using XI, backend is SQL and I'm using a command to get around some performance issues. We need to have a 13 month rolling view of the $ amts and # of units side by side for each month. I suspect in order to put the two side by side, I'm going to have to use a manual crosstab, but I'd LOVE...

You can line up the objects inside of the report to the grid, and make them all the same size (one right under another). That will help clean the majority of the output up.

The value of the slice is 0.0 - it doesnt show on the pie, and it doesnt show in the recordset at all (checked the raw data!) but the darn legend seems to want to insist it be there.

Using Crystal 10.0.0.533 and reporting off of an Excel sheet for the datasource (I know, I know....) I have a chart that looks great, and the user is pleased with the output but I see weirdness that I dont like. Symptoms: Data records found = 8 Chart display shows = 8 Chart has 6 slices (pie...

Sure thing. Above that select statement is this: /****************************Start Member Characteristics ***************************/ SELECT DISTINCT MemberCharacteristic , Result INTO Member_Characteristics FROM (SELECT 'Total Number of Eligible Members' AS...

It highlights the SELECT in the code below - I grabbed just a bit above and below. I just dont see it..... and yes, I will be re-writing it!! first I need to get data... WHERE ( DATEADD(DAY, -1, @i_dAAOD) >= MemElg.EligStart AND DATEADD(DAY, -1, @i_dAAOD) <=...