Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one expalain the procedure for How to create a
Mastr Detail Report in Cognos 8.3 ver?
- 1 Answers
- 4264 Views
- I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
Def-: Two Data Containers can be merged by using common
query item is known as master Detail Report.
Procedure-:
1.)Take a List Report After that Add the following query
items to the List order_number,order_date,Staff_name and
Revenue.
2.)From toolbox drag the list drop beside the revenue.
3.)Add the following query items to the second list
order_number,product_name,Description and Quantity.
4.)From list2 select order_number from toolbar click on
cut.select the Quantity from datamenu select aggregate
click on total.
5.)From Data Menu select Master Detail Relationship click
on new link.From Query1 Select Order_Number,From Query2
Select Order_Number.
Click Ok.
Create a Group on Staffname Query item,
Create a Header on Staffname Query item.
Delete the Staffname HeaderCell,format the Header which is
created.
From run menu click on run.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
can you tell me what are the dimension tables are used in project
can we insert all types of charts in a list report? what r the realtime prompts?
What is difference between informatica power mart and power center?
What is the difference between set functions and filter function in dimensional data?
-----------With out using DrillThrough how to do Reports?
What are the steps to import the two data sources in framework manager?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
what are slowly changing dimensions? Why we are used scd?
What is the use of powerhouse?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
what is the difference between native sql and cognos sql?
How do you call a store procedure within a transformation?
2. What functional area you worked on.
What is the information present in the cognos configuration file?
