Answer Posted / itesh biswal
Simple man
The query from two fact table or two query from 2star
schema with a confirmed dimension always right full outer
join query with a Coalesce of confirmed dim column.....
when u are building a query from 2 fact table but
without a confirmed dimension or having confirmed dimension
not using in query set ,it will right a stitched query
using rsum() function to create his own key and without
coalesce function ....that’s it
And don’t forget you should always try to avoid this
Enjoy
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
How to deploy from one server to another server?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Can you define drill across?
Mention the difference between ‘macros’ and ‘prompt’?
What are slice and dice?
what are the filters in framework manager and report studio?
What are the types of studio present in Cognos?
What are the types of studio?
What are all the types of indexes in Cognos?
What is a Datastore in Cognos?
