Hello All,
I am working with DMR model. I want to create a Regular Dimension with a level(Project) of 4 Query itmes called Project ID ,Project Name,Project Type,Project Status.
I am trying this way with the roles as specified below
Project ID -- business key
Project Name -- Member caption
Project Type-- Member description
Project Status -- No role
after publishing when i open particular package in report studio i am able to see only only 3 Query Items namely Project ID,Project Name,Project Type.
Can anyone please help/guide me what can be done to get all 4 Query items in particular Project level.
Advance Thankscfor any help :)
Quote from: New@cog on 01 Dec 2014 04:52:26 AM
Hello All,
I am working with DMR model. I want to create a Regular Dimension with a level(Project) of 4 Query itmes called Project ID ,Project Name,Project Type,Project Status.
I am trying this way with the roles as specified below
Project ID -- business key
Project Name -- Member caption
Project Type-- Member description
Project Status -- No role
after publishing when i open particular package in report studio i am able to see only only 3 Query Items namely Project ID,Project Name,Project Type.
Can anyone please help/guide me what can be done to get all 4 Query items in particular Project level.
Advance Thankscfor any help :)
Hi,
When you add attributes to a levell in DMR, they don't appear as query items, they show up in the package tree as attributes within the level. Are you looking in the right place?
Here's an example of a DMR level with attributes, expanded in the package tree:
(https://image.ibb.co/cWv8Sk/Package_Tree_Attributes_zps51227b67.png)
Cheers!
MF.
Try these roles:
Project ID -- business key
Project Name -- Member caption, Member description
Project Type-- No role
Project Status -- No role
okay sorry for wrong word . Yes, i mean attributes of a level.
I tried using No role. Its working fine.. :)
Thanks nblank & MF.. :)