About Suvi2020

Suvi2020 · ‎11-22-2021

Hi VA Users, I want to create a cross tab report which will show the End of period values rather than the summing of the values. The data looks like this Category_lvl_1 Category_lvl_2 LOB Value End_of_Month Cat1 Sub_cat1 LOB1 21 31-Jan-20 Cat1 Sub_cat3 LOB1 19 31-Jan-20 Cat1 Sub_cat2 LOB2 31 29-Feb-20 cat2 Sub_cat3 LOB1 24 31-Jan-20 cat2 Sub_cat4 LOB2 54 29-Feb-20 The page filter will be END_OF_Moth So the measure column "Value" Should show the values based on the page filter. Like, if the page is not filtered then it should show 29-Feb-20 values. If let's say the page is filtered on "31-Jan-20" then for cat 1 it should show for Cat1/LOB1 cross tab (21+19) = 40. Is it possible to show like this? Regards, Suvendu

Suvi2020 · ‎08-10-2021

Thanks Patrick! I will be going for option B.

Suvi2020 · ‎08-09-2021

Dear Friends, I did a blunder of deleting some tables from a library through SAS EG. I realized it and created them again and reregistered them in the SAS DI studio. Now the DI jobs are throwing error that the tables were deleted outside the DI job. It’s not showing the tables names but the Metadata ID’s of the tables. Thankfully I have metadata id’s of the deleted tables through which I able to know which are the tables. However when I check the recreated/registered table properties its shows a different Metadata ID. I think if we can find a way to restore the old ID's for those deleted/recreated table that will solve the issue. The question is how we can do it and if we have some metadata instruction code which can force the table to change its metadata ID. Or if we have any other way to solve this. Regards, Suvi

Suvi2020 · ‎04-24-2020

Thanks, @Sam_SAS! I used your suggested method and it works exactly as you have mentioned in your post. The only problem is it's not implementable in the report that I am trying to create as I have lots of columns and an additional column for each original column is not viable in the report. I am not sure why it's not given as a feature in SAS VA as I think it's should be a standard feature(maybe with some restrictions) similar to the feature that is available for the listing report. Thanks again for your solution! Regards, Suvi

Suvi2020 · ‎04-20-2020

Thanks @Joy_SAS ! After going through the documentation it looks like we can only do the display rule by creating condition on "Measure". is it possible to have a rule based on the category? Like I want to highlight it if the row value is "row3" as shown in the sample table in my original post. Regards, Suvi

Suvi2020 · ‎04-17-2020

Hello Members, I am new to VA. I am trying to highlight a row of the crosstab either through some color or through indentation. I searched around the forum and found the below solution. But I don't think this functionality is available in the current version. https://communities.sas.com/t5/SAS-Visual-Analytics/Display-rules-in-Crosstabs/m-p/263004#M3888 Thanks, Suvi Row/Cat Cat1 Cat2 Cat3 Cat4 Row1 1 2 3 4 Row2 2 3 4 5 Row3 2 3 4 5 Row4 2 3 4 5 Total 7 11 15 19

Online Status	Offline
Date Last Visited	‎11-23-2021 01:43 PM

Show End of Period Values

Re: SAS table Metadata ID Restore

SAS table Metadata ID Restore

Re: Highlight/Indent Row Item in a CrossTab Report

Re: Highlight/Indent Row Item in a CrossTab Report

Highlight/Indent Row Item in a CrossTab Report

Re: SAS table Metadata ID Restore

Re: Highlight/Indent Row Item in a CrossTab Report

Show End of Period Values

Re: SAS table Metadata ID Restore

SAS table Metadata ID Restore

Re: Highlight/Indent Row Item in a CrossTab Report

Re: Highlight/Indent Row Item in a CrossTab Report

Highlight/Indent Row Item in a CrossTab Report