Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
- 1 Answers
- 1459 Views
- CTS, I also Faced
- E-Mail Answers
Answer / Devaj Pandey
To join individual tables (X and Y) from a fact table CALLING X in Cognos, you can use the Join Operator. Here's how:
1. Open the Framework Manager.
2. Drag and drop the tables (X and Y) onto the canvas.
3. Right-click on the join line between the tables, and select 'Join...'
4. Choose the type of join you want to perform (e.g., Inner Join or Left Join)
5. Save and deploy your query.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a Cube?
Can we create reports using OLTP database?How?
how to handle multifact?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
What is Parametermap?
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
Use of Text Source Variable in Report Studio?
Tell me about Dnamic and Static Dashboards?
what is hints in cognos and where we use it.
Sales person are there in one company How to do Bursting on this particular requirement?
What is difference between content store and content manager?
How to create a Ratio in Cognos Report studio Reports?
Teradata 
