Explain the design of dimensional model for Internet selling

Ramanagoud

• Mar 17th, 2013

Dimensional model will be having original tables and will be joined directly to other tables using primary key. As in ER modelling we will not do any normalization here. We don't bother about any memo...

BIchick

 Profile Answers by BIchick Questions by BIchick

• Feb 5th, 2010

This is simple layout without stocking/restocking data, also without GL, specials handling, etc...You would have to have these dimensions:Date (including, excluding time - based on how grainual you ne...

Answer Question  Select Best Answer

Can any one explain conditional reports in detail

clarkpca

 Profile Answers by clarkpca Questions by clarkpca

• Jun 14th, 2010

A conditional report is based on the data gathered, then analyzed during the report generation, which reports out results of the analysis in the report's output.

ramandeep singh

 Profile Answers by ramandeep singh Questions by ramandeep singh

• Dec 1st, 2008

In the conditional reports we can make the hardcopy of reports which we want in any angle of database.

Answer Question  Select Best Answer

What is the difference between an agent and a broker?

Inclus12

 Profile Answers by Inclus12 Questions by Inclus12

• Oct 27th, 2009

Yes there is. Let me clarify:-1. An? ?agent represents one? ?Company while a Broker represents the Customer and takes the customer details and goes to multiple?companies to get the best quote and...

smsreddy

 Profile Answers by smsreddy Questions by smsreddy

• May 20th, 2009

Broker is individual and not a part of any organization/company.Agent works for a company for eg : LIC agent works for LIC.

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 17th, 2006

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for softw...

Durga Prasad

• Sep 14th, 2005

BroadCast Agent Service is used for scheduling & Monitoring the Documents.

Answer Question  Select Best Answer

adam89parkar

• Jul 12th, 2007

I worked with MNC where i was having standalone, see in Standalone while working on the side of admin you needed to pay attention on data modelling.If you are starting from scrach then give more look ...

Answer Question  Select Best Answer

kiran

• Sep 17th, 2011

Column selector permits users to dynamically change which columns to appear in results.
Try it in the 'views' in presentation services.

kiran

Answer Question  Select Best Answer

Shirley Reagor

• Jun 17th, 2012

The use of Data Cubes will help performance on queries to an OLAP database. Keeping in mind this will take up additional memory to do.

Answer Question  Select Best Answer

bhanu

• Aug 25th, 2006

As the total charecterstics are 255, out of which 16 charecters are being allowed for foreign keys and 6 charecters are for sap default, for this sake we have only 16 dimention tables, of which 3 are again sap default (unit, time. Datapacket): so finally we have only 13 user dimentions.

VenkateshVandanapu

 Profile Answers by VenkateshVandanapu Questions by VenkateshVandanapu

• Mar 16th, 2006

Because any Database will supports only 16 foreign keys in a database table.

Answer Question  Select Best Answer

kumar

• Jul 31st, 2006

HIHow to create index awareness??Byekumar.

tinku

• Jun 9th, 2006

We can tune the report by using index awarness in universe

Answer Question  Select Best Answer

ABHI2411

 Profile Answers by ABHI2411 Questions by ABHI2411

• Jan 2nd, 2009

Hyperion has a very wide product range which it offers.The widely accepted and most popular tools which distinguishes it from others like BO and COGNOS are Hyperion Essbase(MDDB),Hyperion Financial Ma...

Answer Question  Select Best Answer

Why and how do you use complex join in alias table?

pnagarjuna.technical

 Profile Answers by pnagarjuna.technical Questions by pnagarjuna.technical

• Oct 3rd, 2012

1) When ever the join between the tables is other than equal operator the join is complex join.
2) If we use AND operator in physical join it refers to complex join.
3) In BMM layer we can change the type of join like inner OR outer, this is also refers to Complex join.

Answer Question  Select Best Answer

If there is a problem with time series wizard, how will you do it manually?

ramandeep singh

 Profile Answers by ramandeep singh Questions by ramandeep singh

• Dec 1st, 2008

By using SQL UPDATE Statement UPDATE columnname SET date=()getdate

Answer Question  Select Best Answer

Is Proclarity is the tool most widely used ...or if whats the most popular tool for Business Intelligence......How much we can rate for pro clarity out of 10....Any ideas share it mates.Thanks & Regards

ramandeep singh

 Profile Answers by ramandeep singh Questions by ramandeep singh

• Dec 1st, 2008

BI tools is very much used in data warehouse because with the help of BI tools we can analyse the performance of industries or we can make the history of records within few minutes.

Answer Question  Select Best Answer

Explain the advantages of Business Performance Management.

ABHI2411

 Profile Answers by ABHI2411 Questions by ABHI2411

• Jan 2nd, 2009

BPM is very useful in analyzing the current performance of your business.After analyzing the performance of different operations in your organization you can easily identify the various areas where yo...

Answer Question  Select Best Answer

what is the difference between functions and stored procedures in sql server?

what tool we are using in project management tool for developing packages in ssis?

how to rectify the errors in stored procedure in sql server how many ways are there?

Bapineedu Bollempalli

 Profile Answers by Bapineedu Bollempalli Questions by Bapineedu Bollempalli

• Sep 21st, 2011

Functions can be used with Select statement Not returning output parameter but returns Table variables You can join UDF Can not be used to change server configuration Can not be u...

Answer Question  Select Best Answer

Hi,

This is Srinivasa Rao,Pls help me I am having 3.5 years of experience as SAP BI/BO consultant ,I completed my BSc in 2009

How to tell about my self
pls help me

Thanks in advance

veda

• May 17th, 2017

Sure. Myself , I have 3.5 years of experience working on Business Intelligence,ETL ,and Visualization Tools. I started my career as a BO developer and after couple of projects I started working on B...

Answer Question  Select Best Answer

Shankar

• Oct 22nd, 2011

The table,column, and key objects provide the metadata necessary for Oracle BI Server to access the actual physical sources with SQL requests.

The actual SQL Query which is passing to DB(Data Warehouse).

Thanks,
Shankar

Answer Question  Select Best Answer

can you explain the real time scenario in which we use generic extraction in SAP ECC for SD,FI etc

maheswarrlasekharr

• Apr 10th, 2013

first we install the bi content data source. if any customization fields, add fields extract structure, Replicate the data source into bw it reads complete metadata of the data source and maintain tim...

Answer Question  Select Best Answer

How can i use the hierarchy object as a prompt to filter the data in webi report

Riya Shan

• Jun 7th, 2016

We cannot use hierarchy at the query filter(Prompt ) level. Hierarchy can be used to drill down or drill up the values in the report.

Answer Question  Select Best Answer

1. What is Business Intelligence?
2. Why Business Intelligence is required?
3. What are the Features of Business Intelligence
4. What are the Benefits of Business Intelligence
5. What is Business Analysis?
6. What is Business Analytics?
7. What is Bench marking in Business?
8. What are BI Tools?
9. List few Business Functions

yunis

• May 29th, 2016

It is nothing but fact data reporting.

Answer Question  Select Best Answer