Answer / kumar

select 2 query subjects , then define the relationship 0-1
1-1 if that is between 2 Dimensions.
If that is between dimension, Fact 0-1 1-n {0-1(dimension),
1-n (fact )}

Answer / shaan

Thanks Kumar.

One last query...

Can we edit the relationship in FM in the expression box?
Please excuse me as FM is not installed on my machine now
otherwise I could have checked it.

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers   HCL, Wipro,

---

Can you explain the advantage of using shortcuts?

0 Answers  

---

What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,

2 Answers  

---

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

5 Answers   Mphasis,

---

How to connect three fact tables?

11 Answers   L&T, TCS,

---

How to configure the Cognos configurations to work in the Windows 2000 Server machine?

1 Answers   IBM, Infosys,

---

------------------- What is Busschema?

1 Answers   Cap Gemini,

---

Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....

2 Answers  

---

------------What is Slicer memberset?

1 Answers  

---

what is #prompt and #promptmany, runningtotal in report studio

1 Answers  

---

Diff b/w surrogate Key and Primary Key?

2 Answers   Cap Gemini,

---

I want to schedule the report as sysdate-1.....how to do

2 Answers   TCS,

---