Most business intelligence applications include an element of spatial, or geographic, data-with sales and performance data often analyzed in terms of dimensions such as customer location, geography, and sales territory. Map geographies and business information together to see results. Putting Business Intelligence on the Map By Mark Rittman Source: TECHNOLOGY: Business Intelligence As Published In Because of the Loop Back,the LISTENER.ORA must be updated to reflect the new Static IP address assigned above as part of the Loop Back setup. Then go back and re-configure the Physical Network Adaptor to the way it was (such as DHCP). In the Network Adapter box, click Microsoft Loopback Adapter, and then click Next.Īfter this go into the network setting and look for the loop back network adaptor and configure it with a static IP address, such as (192.168.1.1) as follow:Īfter the above step, if the box lost network connection to the rest of the actual network. In the Manufacturer box, click Microsoft.ġ0. Click Network adapters, and then click Next.ĩ. Click Install the hardware that I manually select from a list, and then click Next.Ĩ. At the bottom of the list, click Add a new hardware device, and then click Next.ħ. Click Yes, I have already connected the hardware, and then click Next.Ħ. Under See Also in the left pane, click Add Hardware,and then click Next.ĥ. Double-click Printers and Other Hardware, and then click Next.Ĥ. If you are in Classic view, click Switch to Category View under Control Panel in the left pane.ģ. Click Start, and then click Control Panel.Ģ. To manually install the Microsoft Loopback adapter in Windows XP, follow these steps:ġ. Its a pre-requisite for OBIEE 11g to call the IP of the host file.It is defined that way,you can go through the documentation for it. You will need to install Loopback adapter to overcome this password error during the 11g installation. They allow the OBI Server to decide on which are the best joins define in the Physical Layer to satisfy the request. When Complex joins are used in the business layer then they are really acting as placeholders. When and why do we go for complex join in BMM layer? For example, Customer Name, Region, Address, Country and so on.ĭimension tables also contain primary keys that identify each member.ĭimension tables are expected to store columns that cannot be aggregated whereas fact tables are expected to store columns that can be aggregated. The Oracle BI Server uses the logical joins in the business model to identify a fact table.ĭimension tables contain attributes that describe business entities. Oracle BI Server understands that any table in a repository that only has many-to-one (N:1) joins to it is a fact table. Measures need to be defined in a logical fact any column with an aggregation rule is a measure. How can we identify facts and dimensions in physical layer?Ī fact table is a table with measures. you need to check or enable so it becomes as a key column.That way you can establish joins. If you dont have joins,then import those tables into physical layer and identify a key column or create a key column in those tables and when you go to properties of the column you find last tab as key. You can use foreign-key join in BMM layer depends on the requirement. Secondly you cant do complex join in physical layer cz you dont mention which key to join in complex join,you just establish a join. Simple understanding is physical layer as it is the first layer in RPD as you import tables you need to establish joins between keys and this is a thumb rule to use primary-foreign key relationships. When ever you build a request in answers BI server first checks in BMM layer to build a query for the request built so you have to have joins right to be able to built query and the main reason is when Complex joins are used in the business layer then they are really acting as placeholders.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |