Answer / phanicrn

I have one dimension and one fact

dimension as Calendar(Calendar_Key,
Calendar_year,Calendar_quarter,Calendar_Month,Calendar_Date)

Fact has(Calendar_Key, Account_Balance, Balance, Amount)

In framework manager i joined
Fact.Calendar_Key=Dimension.Calendar_Key

In Transformer Model when i build the time dimension, i
want the time dimension as
Calendar_Year
Calendar_Quarter
Calendar_Month
Calendat_Date. date should be my lowest level and unique
level. now how do i set scope for Calendar_Date level.
When i look at my fact, I have calendar_Key as key column..

If i put Calendar_Key as lowest level in Time dimension,
when i see the scope. it works.bc'z fact as matching column
Calendar_Key. But how do i set for Calendar_Date as lowest
Level, if i set as lowest level, when i see the scope,Fact
has no column refering to dimension.


what should i do ..?
Thanks
Phani

Answer / vsandhyana

To create the relationship between fact and dimension you
need to have calendar_date also in your fact table and than
only you can make the relationship with that.

diff b/w grouping and aggregation

1 Answers   HCL,

---

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

16 Answers  

---

how u will design the report if the objects are available

0 Answers   Ness Technologies,

---

What do you understand by the term 'model durability'?

0 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.

1 Answers  

---

difference between join and union in reportstudio?

2 Answers   IBM,

---

What are the different type of securities can we apply in framework manager?

1 Answers  

---

How the Bursting happens in same report and how to Print the bursting Report?

0 Answers   IBM,

---

What is value prompt limitations while creating report? What is select and search prompt?

1 Answers  

---

What is the difference between low affinity and high affinity connections?

0 Answers  

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

2 Answers   Infosys, Wipro,

---