cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
syntheticbrain
‎09-01-2015
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received
About
Analyst turned full-service developer in the utility sector in a commodity-risk management environment. Currently a "full-service" developer; operating in all stages of the cycle, from leading requirements workshops to supporting finished solutions. Also supporting administration of the server and managing stakeholder relations.

Re: Force WRS to reload cube?

by Calcite | Level 5 in SAS Web Report Studio
‎10-03-2013 05:57 AM
‎10-03-2013 05:57 AM
I've just had a call from SAS Support indicating that this is not possible - the cube is accessed only once per workspace session. Starting a new workspace session is the only way to see the new data. ... View more

Force WRS to reload cube?

by Calcite | Level 5 in SAS Web Report Studio
‎10-02-2013 10:33 AM
‎10-02-2013 10:33 AM
I'm hoping to use web report studio (WRS) as part of an application. However, during use of this application, the measures in the cube (not the dimensions) will change. I can update the cube while a report is open by running proc OLAP/update-in-place, however, when I hit "Refresh data" in WRS the report still shows the old data. I have to log off WRS and log back on again to get it to reload the cube. Is there any way to force WRS to reload a cube? (Other than logging on & off!) ... View more

Re: SAS BI Dashboard can't access library

by Calcite | Level 5 in SAS Programming
‎08-30-2013 10:54 AM
‎08-30-2013 10:54 AM
Hi Jaap Thanks for the response. Apologies for the confusing reference to RDBMS. My source library is a base SAS one on the Linux server, however, when I was searching for potential reasons why it didn't work I found this http://support.sas.com/kb/40/470.html and I wondered if it might apply to SAS libraries containing relationships as well. While if I'm honest, the reference to keys threw me slightly, it led me to retest something I thought I had already done. The problem is down to physical/OS permissions on the files within the library. They are set to owner: SAS - rw; group: STP - rw; others - list. The sassrv account is not a member of STP and so couldn't access the files. My first inclination is to get sassrv added to the STP group, however I think we need to look, as you say, at the security implications of that. I think it should mean - please correct me if I'm wrong - that web users are still restricted by metadata (within which we have a similarly restricted group) and if people are acessing it physically - either via code or on the box - they need the sassrv password to do anything unless they are a member of the group themselves. Thanks Again Jon ... View more

SAS BI Dashboard can't access library

by Calcite | Level 5 in SAS Programming
‎08-30-2013 06:06 AM
‎08-30-2013 06:06 AM
[Environment info - BI Dashboard 4.31 M1, SAS 9.3 M1. Linux 64-bit server. Win XP/IE7 client.] We recently had EBI installed. While it can access, and report on, almost all of our libraries, it can't access the one library we were actually planning to use it with. Short version: Is there any reason a base SAS library would not be available to BI Dashboard (Very) Long version: The library in question: is defined in metadata has read only and no file lock options set contains 40 tables, most of which are indexed and involved in relationships is readable by the BI developer account - both in metadata and physically contains some tables using custom formats stored in apfmtlib works fine in EG/DI Attempting to create a data indicator via the table method, I get an error stating: Unable to execute query: SQL passthru expression contained these errors: ERROR: Libname STPDATA is not assigned. Aware that BI Dashboard has issues with libraries referencing third party RDBMS' with relationships, and that the workaround is to use an information map, we created an information map, replicated all the relationships, then tried again. And got a different error: Error while submitting SAS code 1          options Locale=en_GB; 2          LIBNAME stpdata BASE "/data/dtf4/demandforecasting/shorttermpower/data" access=readonly filelocks=none ; ERROR: User does not have appropriate authorization level for library STPDATA. ERROR: Error in the LIBNAME statement. I've since created a test library, which I've attempted to make as like the STPDATA as possible (same metadata/OS permissions, primary and foreign keys, custom formats, copied and pasted the library options in metadata). It is read fine by EBI. What am I missing? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Quick links