Resolved : Framework Regular Dimension Level issue

[Nandini.t]

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 :)

[MFGF]

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:



Cheers!

MF.

[nblank]

Try these roles:
Project ID -- business key
Project Name -- Member caption, Member description
Project Type-- No role
Project Status -- No role

[Nandini.t]

okay sorry for wrong word . Yes, i mean attributes of a level.
I tried using No role. Its working fine.. :)
Thanks nblank & MF.. :)