Answer / helping hand

ClosingPeriod()Function is a sibling function
Ref eg:
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14300773

Answer / khushbu

1.firstSibling ( member )
description :Returns the first child of the parent of a
member.

2.lastSibling ( member )
description :Returns the last child of the parent of a
specified member.

Answer / krishna

Returns the children of the parent of the specified member.

how to connect datamarts

0 Answers   HCL,

---

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,

---

How to improve the performance of the report at the report level?

3 Answers  

---

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,

---

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

1 Answers  

---

How do add dynamic titles in PP?

3 Answers  

---

Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 Answers  

---

1. Differences between Merge and Union In Cognos?

0 Answers   Wipro,

---

what is the use of layout calculation?

4 Answers  

---

what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,

---

What is power prompts?Can somebody explain me.

2 Answers  

---

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

7 Answers   Cap Gemini, iFlex,

---