i have 2 fact and 2 dimension tables in my universe . my
question is how get the data with two fact tables in a report?

Answer Posted / sreedhar

There should be a dimension that will connect those two
fact tables which we call it as "Confirmed Dimension"

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

694


What we need to discuss with designer before starting the universe designing.

1822


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3925


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289


What is the dense rank?

679






BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


What is the difference between business requirement document and use case document.

587


What is the difference between user and versatile user?

585


How would you format some text using css to be verdana and bold?

674


How we drill up week to month?

619


Explain the difference between union and group?

632


What is aggregate table and aggregate fact table ... Any examples of both?

614


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

591


Explain about a tricky situation for which you found a very simple solution?

543


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1401