In order to make the OLAP drill through data available as data tables in the Enterprise Guide, all you need to do is change the option to automatically insert the results as a data set in the project. This is extremely useful if part of your workflow includes navigating through
Tag: business intelligence
Using Server-Side filters requires defined prompts with default values in Information Map Studio. But it is extremely important to note that changes to the default values (or adding a default value) to the map while the related dashboard is in use can cause some issues. The documentation has this noted
Recently on the SAS Training & Certification LinkedIn Group, Crystal posted this question about wanting to become a SAS BI developer: “I am a Certified SAS Professional that is interested in broadening my skill set and knowledge by moving into the SAS BI developer realm. What are good courses or
As I mentioned yesterday, some users create portal applications to bypass a second authentication step from the Portal to a Stored Process (via a URL Display Portlet). New in SAS 9.2, there is a STPRun directive that allows you to just complete one single step (create a URL display portlet)
In 9.2, the right-mouse click functionality is not available by default. To switch back to this (which for STP developers in a DEV environment is essential to our productivity), SAS has provided the following note: http://support.sas.com/kb/39/292.html As you can see, out-of-the-box, all SAS STP developers will need to do is
In SAS 9.2, internal accounts can be created and utilized within the metadata and then do not require host (or domain) accounts defined elsewhere. By default, the sasadm@saspw is one such internal account. Unless you specifically declare an exception, the server-level policies for routine password resetting and locking (such as
SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY - this generates the lowest level of summary for use in the OLAP cube. Essentially - the class statement contains all
In the past couple months, this scenario has occurred twice. So thought I'd share a quick remedy ~ and save for my future reference when this occurs again :). In Star Schemas, there are sometimes occasions where the data quality isn't exactly perfect. And sometimes, for some users/companies, this is
OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn't correct. Essentially, it was calculating the custom measurement
In 9.2, OLAP Cubes can be updated incrementally. This is awesome, as you then don't have to worry about users locking your cube by closing the Web Report Studio window or leaving their EG session running. However, at the same time, this can cause the size of space an OLAP