can we use detail in generation of reports? if customer id
is a dimension in a report, what will happen if we define
it as a detail?

Answer Posted / mj

Detail object means,It should give detailed information for
some dimension object.
You can use these objects in your report generation.
When we drag the object in query panel,It'll automatically
feteches it's corresponding dimension object also.

Detail object:-
It gives extra information to the dimension object.
Eg:-

customer id is a dimension object
Detail object of customer id is customer name ie..first
name,middle name,lastname,Address,Phone number.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

545


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

580


Explain is data mart?

580


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...

1713


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

592






Can we configure two instances of CMS pointing to two different CMS system databases?

1482


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??

3908


What task is 98% of the required work of a business analyst?

571


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

615


U r project in which stage in implementation?

1942


What Is Snow Flake Schema?

660


how to create metric universe ?

1889


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1469


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1807


How to generate the report from excel sheet?

576