I think you need to chang the aggregatge function on your calculation to 'calculated', and also for the roll up calculation. Then in the report add the subtotals and they should automatically calculate for each subtotal level.
I've had a few issues in this area too, so I'd be grateful to know...
Hello again all!
I am using cognos 8.4, and have a crosstab report with multiple nested rows, a couple of columns and one measure.
I would like to have a header for the rows, much like is automatically generated with a list. I've tried the following to no avail:
1. Add cross tab space and...
Sorry for not being clear enough, it's pretty difficult to explain. Basically I would like to find a statement to use in a query to detect whether any of three optional prompts have been completed (that is, a string has been entered by the user), without requiring the user to enter a string for...
Ties, I was just wondering if you could help with the final step on this for me? here's the scenario...
Again using 8.3 Report studio, I have a list report which is based on query 1. Query 1 is a join between Q2 and Q3, using outer joins on 5 data items, plus lots of additional calcuated data...
Hi all
I'm using report studio 8.3, and have in the past selected "no data" in the run options to run a report without data in order to view the output formatting.
I have also in the past created jobs in cognos connection that run a list of reports (some with default values, others with...
Just to clarify having read it again - I want the calculated data item to return the corresponding data item to any one of pCRM1,2 or 3. Only one of the pCRMs will be completed, therefore I need to change the "is null" operator to something that checks whether the prompt has been completed, in...
Hi all
Using report studio 8.3
I have a prompt page with many prompts, many of which are controlled using hmtl item. Simply put the html ensures one of 3 prompts must be completed before "finish". Thus after selecting an item in prompt 1, if the user selects an item from prompt 2, then...
Not my day today, I didn't read your post correctly - it seems to work, (in that I don't have an error message), but it is taking a lot longer to run the report now.
I'll keep you posted if it works. Any ideas on improving the performance?
Thanks very much Ties
Sorry Ties, should have been clearer, it was quite late when I posted!!
The objective is to filter the year of my selected data items depending on the value of pID, thus
when pID is between x and y
then filter data for year = z
I am therefore trying to use the THEN and ELSE clauses to return...
Hi all
Using 8.3 Cognos report studio.
I was someone could tell what is wrong with the follwing case statement, used in a detail filter in a report:
"CASE
WHEN ?pID? between 73 and 84
THEN ([GMT Product Overview by Asset Class].[Product Overview Facts by Asset Class].[Year] = 2006)
WHEN...
Hi all
Using Cognos 8.3 report studio.
Sorry if this is an obvious one, but I've been racking my brains on it for a while.
I have a search and select prompt which is used to select parameter value(s) to be referenced in a query filter. My filter expression is therefore:
dataitem in...
As you can probably already guess I don't know too much about these things...The temporary table (I call it a "table" but it is an sql query that produces another normal query) is created using the following sql:
"select 'Unconstrained' as Text,
'A' as Category,
2.0 as part_1000,
1.3 as...
Hi all
I need an efficient method of obtaining the value of cross section of a table (manual and ad hoc table generated using sql query) in a query. I would like to avoid using "Case When" of "If" constucts as the table is very large.
I have investigated using "tuple" but understand this is...
Ties,
Could this also lead to having different results when running the same report on pdf and Excel?
This is the situation i am in, where the excel report is correct but pdf incorrect, despite being the same report!!
Very strange...
Hello again all...another issue I know!
I have a cross tab that contains 5 measures (all calculated), grouped by one member in the column and 4 members in the rows. For each row member there nested total line, which performs a sum of the crosstab fact cells.
The trouble is that for one...
By way of an update, I guess in case anyone else has this problem, I solved the issue by creating a duplicate of the existing [Revenues YTD] data item in the offending query and replaced the measure on the report page. Bit of a fluke really, but bizarrely this only works when the old data item...
The base query runs fine, but the report query only runs when I delete the 4 total calc's I mentioned before, which also deletes the rows from the report:
total(currentMeasure within detail [Team])
total(currentMeasure within detail [Submarket])
total(currentMeasure within detail [Sub-GMT])...
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.