March 4, 2008 at 1:51 am
Hi,
I am new to Reporting Services,as i usually use Business Objects.
I have a dimension table that has RECORD_START and RECORD_END date fields this is so that reports can show historical detail of a given property (house).
I join that to a fact table that shows charges in it that joins to the dimension using the natural key property ID. This is because it is effectivlly a many-to-many join between the fact and the dimension.
In a Business Objects universe, to resolve this many-to-many I would join using the natural key, and then use a prompt to ask for a snapshot date from the user prior to the report being generated.
Is there a way to create a prompt within the join conditions in the reporting model? Or can I only achieve this at report creation?
Any help much appreciated.
Pete
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
March 14, 2008 at 9:29 am
Can anyone help with this?
Thanks
Pete
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply