Navigational attribute

[waqar_ahmed]

Dear Experts,

I am creating a query on employee subgroup and their hiring monthwise. Employee subgroup is attribute of Employee and it is defind as navigational. If I make Employee "No Display" and Employee subgroup as "display" it gave me an output like

Bps17

Bps17

it repeat the subgroup, secondly I cant see employee subgroup in separate navigational attribute folder when I load cube in query designer. plz provide some useful suggestions

regards,

ray

[Former Member · Accepted solution]

Hi Ray,

As far as i can understand you have built the query on a cube. This cube contains 0EMPLOYEE.

In 0EMPLOYEE you have made employee subgroub navigational.

So have you made ticked the 0EMPLOYEE_employee subgrouip under navigational attributes in the cube.? Check that.

Once it is done you will find employee subgroup as a separate entity in your query on the left side and you can just drag and use it.

hope it helps.

thanks,

rahul

[waqar_ahmed · Accepted solution]

HI,

I have checked on/off button in the cube for employee subgroup, after activating the cube I reopened the designer but I cant find it in separate folder. Though I can see this attribute in cube nav folder. Is it a right way or any other suggestion

regards,

ray

[Former Member]

Hi There,

Please check the master data for 0employee whether it is loaded properly or not.

As u discussed, you are gettigng 2 records with same description

Bps17

Bps17

so check what is key against that 2 records with same description.

After loading and activating the master data for 0employee, load the transactional data again and check.

Regards,

Rajdeep Rane.