Recent content by ejaycognos

please let me know how sub reports are created in report studio and how it is called in the main report?? using cognos 8.4 Thanks

I have a Scenario where one main report pulls in many sub-reports around 10. Remember each report has a union of 6 queries pulling for a particular month. This can be done in separate 10 reports also but if cognos has that capability then thought of trying it. Wouldn't be a good report design...

XX XY XZ Total /Avg _________________ A M1 10 10 10 30 M2 4 10 1 5 M3 3 3 15 7 where M1 M2 M3 are measures. M1 should give Total M2 and M3 should give average how it is possible incognos??? conditional formatting? please help..

here is the scenario .. In a crosstab report, need to dynamically change the column based on prompt , so created a calculated column 'x' and placed in the report as crosstab row. x=if(?prompt1? is not null and ?prompt2? is null) then 'column1' else if (?prompt2? is not null and ?prompt3? is...

This is acheived using a prompt calculation and put it in the row field.

I am sorry I was wrong in my question.. I need dynamic row to be displayed in the output based upon the prompt value selected ...

so in my case I need to build 3 crosstab in each 3 different pages and use the render logic to hide and show the pages??? If so , i never done this could you please explain the steps?? thanks so much ..

how to hide cross tab row based on prompt value without messing up the column title?? I did: I created a boolean variable on report page, clicked on the row which I want to hide. set the boolean variable to style variable select box type = none. o/p: the required row was hidden based on...

I created the prompts for all 5 levels and before created a conditional string variable , do I need to create static choices. could you please explain the steps , ejaycognos@gmail.com. I have worked with only hide and show objects , these conditional variables are bit confusing going thru few...

Here is the scenario .. Level 1 (Required Prompt)-> Level 2(Required Prompt)-> Level 3 -> Level 4 -> Level 5 -> Level 6 High Level -> Low Level In a crosstab with multiple measures , If the user selects Level 3 prompt, the o/p should group by Level 3 and in o/p shows Level 4. If a user...

got it works fine

union all also takes some time. or should I contact cog support , to clear some space in temp folder and increase its size if needed? I did some reasearch in cog document and they told to check on the available space in temp folder.

Thanks blom for clarifying the UNION All query. I guess then using UNION ALL may improve the performance , I am going try with union all. Thanks bicog8 for your reply .. no I haven't tried this , I will create a test report and implement this scenario and will inform how it worked.

Thanks blom for the reply. I have only access at report studio level,how to create a cognos sql object? I have not worked much on these union , pls guide. Also, in Union I set the properties to Remove duplicates , so still I need to consider Union All ? This is what I done in my rport : I...

Ideas To improve the runtime of report at report level? using UNion query of combinng 3 query in a crosstab with 5 measures. All the calculations and filters are done at union query only , as at individual query it throws some error , thus doing it at union query. The execution time is very...