Answer Posted / zeya.ocp

CASE Expr make u use IF-THEN-ELSE logic in sql statements without to invoke procedure.It complies with ANSI SQL.
DECODE function decode an expr in a way similar to IF-THEN-ELSE logic that is used in various languages.it facilitate conditional inquiries.

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3778

---

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?

1971

---

What we need to discuss with designer before starting the universe designing.

2194

---

What are the join problems comes appart from loop,chasm & fan Traps

2056

---

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1087

---

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

4358

---

Explain what are the measure objects?

933

---

What is the difference between slice and dice and cross tab report?

993

---

what is the difference b/w the refresh and buffered data?

2267

---

When we use aggregate awareness function in designer?

907

---

what are the day to day activities of BO administrator ?

2970

---

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.

2390

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1052

---

What is the difference between business requirement document and use case document.

957

---

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

975

---