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

Thiru

• Oct 4th, 2007

Degenerated dimension keys are keys in the fact table that are not dimension keys (Foreign keys to the Hiearchy/dimension tables) and measurements. Like, Order Number, Invoice Number etc.

sithu

 Profile Answers by sithu Questions by sithu

• Mar 24th, 2007

A Degenerate dimension is a Dimension which has only a single attribute.This dimension is typically represented as a single field in a fact table.Degenerate Dimensions are the fastest way to group sim...

Answer Question  Select Best Answer

ravimantur

 Profile Answers by ravimantur Questions by ravimantur

• Jun 12th, 2009

Create a Alternate Drill down   like if region is the name of dimension and the hierarchy is RegionCountry          Branch NameBranch Name &...

rreddyj06

 Profile Answers by rreddyj06 Questions by rreddyj06

• Mar 5th, 2008

Its better to use drillacross.

Answer Question  Select Best Answer

idanh79

 Profile Answers by idanh79 Questions by idanh79

• Dec 1st, 2009

You can use calculated members in OLAP cube?and change the format?accordingly the value of the cell.Idan Halfon?

sithu

 Profile Answers by sithu Questions by sithu

• Mar 24th, 2007

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers,Sithusithusithu@hotmai.com

Answer Question  Select Best Answer

sami

• Oct 14th, 2007

1:1 statrschema relatioship1:m Parent-child relatioshipn:m sanwflakes relatioshipthanks,sami

sudha

• Jul 28th, 2006

hierarchy relation ship shows the relation between the desired attributes in the table

Answer Question  Select Best Answer

maheswarrlasekharr

• Apr 10th, 2013

Just install the ready made business objects and activate it, replicate into bw install suitable info source then onwards extract the data from R/3 to bw run info package.

Sleekpage

 Profile Answers by Sleekpage Questions by Sleekpage

• Dec 20th, 2009

Business content can come from various parts of your business operations. Some from the finance department and some from the sales department.If these business content are consistent and can be used b...

Answer Question  Select Best Answer

I would like to know the exact definition of the term Dashboard. As of late there has been a great deal of confusion on the overuse of this term in my workspace. I was under the impression that this term referred to analytical graphs that were designed to mimic speedometer displays like a dashboard in a car. Lately, it seems that people are using this term to apply to any form of analytic graph...

sithu

 Profile Answers by sithu Questions by sithu

• Jan 10th, 2008

Dashboard is a user interface that organizes and presents information in a way that is easy to read. In regards to Business intelligence dashboard is a reporting tool that consolidates aggregates and ...

jd_usnj

 Profile Answers by jd_usnj Questions by jd_usnj

• Dec 24th, 2007

I agree with you that it's like a car dashboard you can visualize every thing. but it works diffrent here. In detail we monitor our enterprise business process goals. In technical way KPI and then...

Answer Question  Select Best Answer

Explain about T-Codes and where can you find the list of T-CodesRaakesh

balaramtripathy

 Profile Answers by balaramtripathy Questions by balaramtripathy

• Nov 16th, 2010

T-Code are Transactional Codes in SAP it will quick navigate to a particular screen.We will find all the T-codes, on the following steps,Got to SE16(t-code)then type TSTC on barthen executive, and ag...

suyogpatil09

 Profile Answers by suyogpatil09 Questions by suyogpatil09

• Jan 7th, 2010

T-Code are Transactional Codes in SAP,  it facilitates the quick navigation to a particular screen by entering the T-code for that transaction in the textbox provided on left side top corner.&nbs...

Answer Question  Select Best Answer

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

Andy

• Jul 18th, 2007

Hyperion has different modules such as essbase, interactive reporting, financial reporting and production reporting. Each tool has its own functionality. Hyprion interactive reporting and essbase are OLAP tools.

Om Prakash Bang

• Sep 21st, 2006

Hyperion ia a Business Intelligence (BI) and Business Performanc Management (BPM ) Tool.  Its a market leader in Financial, Operational and Strategic Planning. It is having applications for Plann...

Answer Question  Select Best Answer

attiliasp

 Profile Answers by attiliasp Questions by attiliasp

• Sep 19th, 2008

Hyperion?essbase?internally?act?as?a?ETL tool.?Hyperion?tool?is?used for?OLTP, since it?can?analyse the?history?of?the?bussiness?data.

sithu

 Profile Answers by sithu Questions by sithu

• Nov 18th, 2006

It is an OLAP tool, which gives lot more options in fine tuning your reports,Cheers,Sithu, sithusithu@hotmail.com

Answer Question  Select Best Answer

kishore

• Nov 26th, 2013

If we create an aggregate on a dimension which has less than or equal to 16 characteristics, then it is act as a line item dimension, This type of aggregates are called flat aggregates. my personal re...

JAGADISH RAJU

• Sep 14th, 2011

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

Answer Question  Select Best Answer

sithu

 Profile Answers by sithu Questions by sithu

• Jan 10th, 2008

ODS Data will be keep on changing...that only we are unable to do

Cheers, Sithu

Javid

• May 3rd, 2007

Hi,This is a common question, asked anywhere.While loading into the Datawarehouse we gather data(source) from different source systems and place it in a STAGING area - which is literally called as ODS...

Answer Question  Select Best Answer