This is quite difficult for me to communicate so please bear with me.
I have created my data source view in my solution. I have a central fact table surrounded by the dimensions. Several of the dimensions have dates which I converted to integers. Thinking that I would need separate date dimension tables so the date integers
could find their dates I created a data dimension table "snowflaked" to the dimensions with dates.
An example is my dimPolicy table has dates of creation and ending.
I converted these to integers.
A table called dimPolicycalendar was made in the DSV and then linked. A dimension snowflaked to a dimension.
When I went to create a dimension for Policy it auto attached the dimPolicyCalendar. Then all my dates disappeared. And the generic values in the dimPolicyCalendar appeared.
HELP HELP HELP PLEASE!!!
How do I get my values back?
If I wasn't supposed to add a calendar table to the dimension how will I convert those integer values to the date values I want?
I am panicking a little because I can not find any helpful resources.
You are my last hope before we are pushed to an Oracle solution. Yuck!
View Complete Post