BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Davi3
Fluorite | Level 6

Hi everybody !

 

 

I' m doing a small report which aggregate the revenue of different category of people. The category is managed with a Hierarchy.

A row of the dataset ( an output of a query ) is composed by

 

OFFICE NAME, SURNAME, CODE CATEGORY A, CODE CATEGORY B, REVENUE

 

Category B is a "subset" of Category A.

 

My problem is :

 

if I do a hierarchy with SURNAME, CODE CATEGORY A, CODE CATEGORY B, REVENUE the report is good.

if I do a hierarchy with Office Name, CODE CATEGORY A, CODE CATEGORY B, REVENUE the report is worng and on the report I receive an error. It's translation is : Impossible to find a column referenced from the query. 

I attached a screen-shot .

 

Can you suggest me how avoid this problem ?

 

Thanks a lot in advance,

regards

 

 

 

 

 


Immagine.png
1 ACCEPTED SOLUTION

Accepted Solutions
Davi3
Fluorite | Level 6

Hello folk,

very sorry for the missing replies.

 

To close the segnalation i would inform you that the problems seems to be a bug.

 

I use VA 7.1, when the mentioned messagge appears, I need to disconnect the current SAS VA users and login again.

 

Thanks you for your time,

have a nice day

 

 

View solution in original post

3 REPLIES 3
SAS_Mike
Obsidian | Level 7

Hi Davi3,

 

Just to clarify, are you replacing Surname with Office Name, or adding in Office Name above Surname?

 

Are there multiple tables joined together for this report, or are all of those items from one data source?

 

Thanks,

 

Mike

PeterWijers
Lapis Lazuli | Level 10

Hi davi3

are you absolute sure that the selected drill-down has a data hit at all.

i have never experienced this behaviour in the 2 last years, besides if there is noting left to show.

greetings Peter

Davi3
Fluorite | Level 6

Hello folk,

very sorry for the missing replies.

 

To close the segnalation i would inform you that the problems seems to be a bug.

 

I use VA 7.1, when the mentioned messagge appears, I need to disconnect the current SAS VA users and login again.

 

Thanks you for your time,

have a nice day

 

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1427 views
  • 0 likes
  • 3 in conversation