Answer / palzkumar

Slicer Member Set is nothing but a set expression that returns
members from a single hierarchy of a single dimension.

This can be done only dmr model..
-palzkumar-

1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?

1 Answers  

---

What are variable report studio?

1 Answers   HCL,

---

----------------What is Scopr Relationship?

1 Answers  

---

Explain what is the difference between microstrategy and cognos reporting tool?

0 Answers  

---

how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers   TCS,

---

how can i provide security to my reports in report studio?

3 Answers   TCS,

---

How to apply securities for reports in cognos connection?

0 Answers   TCS,

---

Why need staging area database for dwh?

0 Answers  

---

-------------What is a Conformed Dimension?

3 Answers   Bank Of America,

---

What is set to be Cognos configuration?

0 Answers  

---

11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  

---

diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,

---