BookmarkSubscribeRSS Feed
Matthijs
Obsidian | Level 7

Hello,

 

I've encountered something strange.

We've build a report direcly on a table (so no cube or information map). The report seems to work. BUT.... When I 'alter' the data (just a calculated value) in SAS EG the data in the report in WRS doesn't change. We've tried:

- Refresh report in WRS

- Save report, close report, reopen report in WRS

- Save report, close report, logoff WRS, login in WRS

- Save report, close report, logoff WRS, start new browser, login in WRS

- Change saved location and let another user login an open the report

- Alter refresh-preference in WRS (automaticly to manualy en back)

 

Doublecheck

- In EG we see the correct results

- In a new EG-session we also see the correct results

- Refresh metadata in management-console (why..... we didn't change structure, just a calculated value)

- Refresh objectspawner

 

So why isn't the report showing the correct values?

2 REPLIES 2
Kurt_Bremser
Super User

Are you POSITIVELY sure that you access the same physical dataset in both applications (EG and WRS).

I ask that because we often have a separation between base datasets and datasets registered in metadata for use in WRS.

The latter are updated regularly via batch jobs, to separate "working" datasets from "report" datasets.

Specifically, look how a possible information map is defined.

Matthijs
Obsidian | Level 7

Thank you for your question. It made me question my own assumption. And you are correct (as always). It is not the same datasource. The report(s) are build on the 'shared data' where as the psychical data is stored somewhere else. That means I'm depending on a batchjob, as you pointed out.

 

Now I have two options.

1. Find out how to trigger a refresh/update batch

2. Use a cube or information map because I know how to trigger a refresh there

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 835 views
  • 1 like
  • 2 in conversation