Post reply

Report Model / Reportbuilder Question: lookup on non unique column?

  • February 14, 2008 at 9:05 am

    #203480

    I have just been through the Report Model tutorials and I can't figure out how to do this...

    I have a typical dimension table DimCampaign with the following columns:

    - CampaignKey (surrogate key)

    - Brand (non unique)

    - Campaign (non unique)

    I created a model with pretty much the default options.

    In Reportbuilder, I would like to create a Report with a Parameter on the possible Brand values but Brand is not a "IdentifyingAttribute" within DimCampaign... because it's not unique.

    Can I do that?

    Do I need to do something special in my model?

    Many Thanks

    Eric

    :crying:

  • February 14, 2008 at 9:52 am

    #778450

    OOPss!

    I had probably damaged something in my model as it's working fine now.

    (I had assigned my entity to the Primary Key rather than the entire entity... or something like that)

    Sorry if I made you scratch your head needlessly

    Eric

    :ermm:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply