Answer / varma

dimension are descriptive information. for example customer
name,address. where as regular dimensions are used to create
the hierarchies in dimensions. for example let us take
product dimension.

u can create hierarchies in product dimension using regular
dimension. u can create hierarchies as product
number,product name, product line code,product description.

the regular dimensions are used in analysis studio for drill
down and drill up methods

1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports

1 Answers   CTS,

---

What is the difference between a cascading report and drill through report?

0 Answers  

---

When we deploy the report to live the client get the data error how can we resolve that

1 Answers   CTS,

---

What is Cardinality b/w Fact to Fact?

4 Answers   IBM,

---

what is dash board?

2 Answers   Syntel,

---

Where in report Studio's property pane can I find NoDataHandler?

1 Answers  

---

what is sdibling function tell me the some functions

3 Answers   IBM,

---

What is the difference b/w macros and prompt?

0 Answers  

---

What is the difference between macro & Parameter

1 Answers   IBM,

---

-----------With out using DrillThrough how to do Reports?

0 Answers   IBM,

---

If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

4 Answers   IBM,

---

How can we improve performance in framework manager level?

3 Answers   Wipro,

---