Maybe this is just my lack of SQL experience but how would 'O.[2010] = N.[2010]' work if 2010 doesn't exist in Table1?
Also, I don't think I see how this would work when Table2 brings in a new combination of Company,State and line with the right join
thanks,
-Eric
Lets see if this helps:
Existing table 1:
Company State Line 2005 2006 2007 2008 2009
A NY P 100 200 200 300 400
B PA L 100 200 200 300 400
A PA Q 200 230 300 400 400
New Table 2:
Company State Line 2010
A...
Thanks for the reply. You're right, the structure is horrible but there are so many things built off it that it would be a huge project to change it.
I thought of an append query but then I would just have double the records and the attributes would be doubled in some places. One thing that...
I have an existing table with about 10 attributes and columns for 5 years of data. I want to take another table with similar attributes but only one year of data and update the first table. This one year is for a new year which does not exist in the first table. For example:
Table 1
attr 1...
Maybe I'm not understanding what you're doing but even if the prompt is optional, it still needs to show. I have your issue myself and I've had to create two separate reports. One with the date logic built into the filters and another for the user to use with the date they want.
-Eric
I apologize if I'm asking this wrong but does Cognos support AJAX at all? If not, does anyone know if there are plans for that. I talking about AJAX support for Cognos Connection and non-'studio' work. I find it very cumbersome to manipulate reports between folders with the constant refresh...
Our Admin figured it out. I had a join between two queries. In one of the queries, I had a calculated field on top of the list in the Query explorer window and the item I joined with below that. She flipped them and it worked. We're not quite sure why it worked. I don't see how that and...
I'm using Report Studio 8.3. I have a report that validates fine and I get output with html but when I select any Excel or PDF option I get the following error:
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the...
Since our tables are updated nightly, I made sure that the report is scheduled mid-morning to avoid time issues. The only time I will have problems is if there are technical problems on the backend and the database isn't updated correctly. But that's always an issue with whatever you do...
Thanks, that gave me the general idea of what to do. I had to use different functions but the idea was the same. I'm using Cognos Report Studio 8.3. I apologize for leaving that out before. The statement I used for one of the dates was:
(IF (_day_of_week(current_date,1) IN (1,2)) THEN...
I have a report that has two date prompts that needs to be scheduled Mon-fri, but the dates are different based on what day of the week it is. My chart is (Date1 and Date2 are referring to the day in the previous week):
Today Date1 Date2
Monday Wed Thurs...
It was the Google toolbar. I noticed she had it yesterday and I totally forgot about that messing up a lot of web applications. She allowed pop-ups and it worked and then she just uninstalled it since thre was no need to have it.
Thanks for the help. I looked at IBM support but I must've not...
I know this is not a Cognos issue but it seems to have only come up with one of my users who is trying to output reports in either Excel or .csv format. Most of the time, the report runs, a box pops up for a split second (Way to fast to see if anything is in it) and then closes with no output...
When I used your SQL (and other methods to reformat) I get:
An error occurred while performing operation 'sqlOpenResult' status='-28'.
I'm not sure what that's about. Any ideas?
thanks for the help.
I have a data element that is formatted as text. The are actually dollar values. I need to find a way to transform them in Cognos to be able to sort in value order, not text order so instead of:
$1,000,000
$5,000
$70,000
I need it to be:
$5,000
$70,000
$1,000,000
If I knew the list of...
I think I'm either missing a really easy concept or looking at this the wrong way. My problem is that want a filter to be 'optional'. What I'm doing it I'm prompting the user if he wants to use a filter. If Yes is selected, then the data is filtered, if No is selected, then all data...
I thought I saw this somewhere but I can't seem to find it. I have a list report from Report Studio 8.3 where I have 2 data elements plus the month number (Jan=1, Feb=2, etc) and then a count. I concatonate those first three fields so I have that and the count. The problem is that not every...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.