What is the architecture of ur project? can u explain it? PLz
Answer Posted / pk
Architecture of the project means..
1.Your Source and Target System.Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4.Loading strategy like which u applied type 1,2 or 3.
5. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
6. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many reports have u created ? explain a few.
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?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain how to schedule the report in b.o?
Can anybody tell me what are the tuning problems?
What is object stores?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How to open a universe with out using the Designer ??
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain what are the steps to do to use alerts in bo?
in sap bi we have wad, then why we go for sap bo
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?