About Allan_dk

Allan_dk · ‎09-18-2014

Beginning Date vt_start %sysfunc(datetime()) End Date vt_end '01Jan9999:00:00:00'DT Except from that we use 9999 instead of 5999 you are correct.

Allan_dk · ‎09-18-2014

vt_end has 0:0:0 because it is just testdata. There are no columns under SCD1 /* Close out any records that are in the xref table but not in the source. */ else if inXref and not inSort then do; ETLS_CLSDATE = DATETIME(); output work.etls_close; end; run;

Allan_dk · ‎09-18-2014

In the transformations propeties/options it is possible to activate Close out records not in source table: For records not in source table, assume they are to be closed out in target table. When a record is missing in the source data the transformation set the validtime_end til %SYSFUNC(DATETIME()) and that is what I expect. Before ID vt_start vt_end Value 1 01jan2014:0:0:0 15mar2014:0:0:0 A 1 15mar2014:0:0:0 31dec9999:0:0:0 B After the record is found missing ID vt_start vt_end Value 1 01jan2014:0:0:0 15mar2014:0:0:0 A 1 15mar2014:0:0:0 17sep2014:0:0:0 B But the next day the transformation runs it apparently updates the record in the target table. ID vt_start vt_end Value 1 01jan2014:0:0:0 15mar2014:0:0:0 A 1 15mar2014:0:0:0 18sep2014:0:0:0 B I lose track of when the record was detected missing. What to do? DI-studio v4.6

Allan_dk · ‎09-02-2014

You are not missing something. I have the same problem. My solution: I have to identical sections; the first with a slider and the second without. When the user opens the report he sees the full period. If he want to change the period he switches to the other section. I have the same problem when I use a drop down list with months. Then I wish that I could set default value to current month. There I have a similar solution, where the first sections only show current month, and to see the historical data, the user has to change sections.

Allan_dk · ‎09-02-2014

Sorry, I forgot that you can't change format to date. So, yes - you are stuck. :smileycry:

Allan_dk · ‎08-28-2014

Hi You just have to duplicate the date variable and rename it first date. Then change the aggregation to minimum. The same goes for last date. But you cant use the variable in filters. BTW: There are a lot of helpful people in here, but they never notice that it is Visual Analytics forum, and always come up with answers in BASE SAS.

Allan_dk · ‎08-22-2014

Yes i am familiar with the Change Data Source option and the Repair Reports Prompt. But I was looking for at way around those options.

Allan_dk · ‎08-22-2014

I have tried the waterfall chart. But I have not been able to calculate the percent, so it will only be en actual sales numbers. The link should be working again.

Allan_dk · ‎08-22-2014

This is a problem I have in Visual Analytics not Base SAS.

Allan_dk · ‎08-21-2014

Is the costumers moving to Internet/Catalog? If I look at the numbers in this report based on Orion Star we will see that In 02.2007 there was sold 720 items in 01.2012 there was sold 1674 items http://databank.socialstyrelsen.dk:8080/SASVisualAnalyticsViewer/guest.jsp?reportPath=/Public/&reportName=Orian%20star%20percent But what I really want to show is that in 02.2007 it was 8 % in 01.2012 it has dropped to 7 % How do I show that in the best way? We are running 6.3 but expect to jump to 7.1 when available.

Allan_dk · ‎08-21-2014

I have to move a data source from one folder to another. But there are a considerable number for reports and explorations already using it. What is the easiest way to do so?

Allan_dk · ‎07-09-2014

My it-department have changed the domain from ipaep to koncern. That means that I have to change it for all useraccounts in the User Manager, and that will take some time. User/Account/Userid = ipaep\abc must be changed to koncern\abc. How can I make a search and replace for all the user accounts?

Allan_dk · ‎07-08-2014

Just to specify. It is the datasets loaded to memory in the LASR-server. There are no physical files, therefore sashelp.vtable.filesize=0 proc datasets don't give me much information.

Allan_dk · ‎07-08-2014

Where do I find the size of the datasets loaded to memory? I now have more than 50 tables loaded in the LASR-server. The Sizing Guideline for Single Machine have a guideline about largest individual table size (16 GB) total GB loaded to memory. (180 GB) I can only find information about number of rows and columns.

Allan_dk · ‎06-21-2014

If you set the logging threshold to INFO the log will contain information that you then can analyze. You can get information about reportId, user, time, action.

Online Status	Offline
Date Last Visited	‎05-30-2016 08:24 AM

When was data last updated

Date based aggregation i SAS VA tables

Re: SAS.IdentityGroups in Conditional Grants

Re: Best practice for storing and sharing tables

Re: Best practice for storing and sharing tables

Re: How do you use SAS Theme Designer for Visual Analytics? SAS wants ...

Best practice for storing and sharing tables

Re: Range Slider Date Help

Re: About Percentage

Re: Comparing one entity with the average of the population

Export to Excel in SAS Visual Analytics Modern look (HTML5)

Re: Export to Excel in SAS Visual Analytics Modern look (HTML5)

Re: Prompt on reportlevel

Re: 100% Stacked Bar Charts

Re: Finding No of Days between two dates in SAS VA

Re: Usage Statistics of VA Reports

Re: Removing table border line

Re: Determine the current user in Visual Analytics

Prompt on reportlevel

Radar Chart

Re: How do you use SAS Theme Designer for Visual Analytics? SAS wants ...

Re: DI-studio : SCD Type 2 - close out records

Re: DI-studio : SCD Type 2 - close out records

DI-studio : SCD Type 2 - close out records

Re: SAS VA - Date Range slider issue

Re: How to find the first record date and last record date for each gr...

Re: How to find the first record date and last record date for each gr...

Re: How to change data source on 100 reports and explorations

Re: Best way to follow percent over time

Re: How to change data source on 100 reports and explorations

Best way to follow percent over time

How to change data source on 100 reports and explorations

How to search and change multiple user accounts

Re: Where do I find the size of the datasets loaded to memory

Where do I find the size of the datasets loaded to memory

Re: Usage Statistics of VA Reports