There is no good way to migrate MDDBs to V9Cubes. Here is an excerpt from the SAS migration website (http://support.sas.com/rnd/migration/planning/files/mddb.html): “There is no automated method to convert Version 8 MDDB code to SAS 9.1 OLAP code. PROC MDDB executes in SAS 9.1. However, it creates a Version 8 MDDB that
SAS BI-ogsource is now 2 years old! Hope everyone has enjoyed the content over the years. Please feel free to contact me with feedback, suggestions, or even ideas for new posts! BI Weblog Email Address
Overall, query response time dramatically decreases with the use of sets, therefore it is preferred that user selections (or the cube itself) prevents the potential of choosing multiple members within the same dimension. Queries that only included 1 member in the slicer but are still represented as a set are
In order to promote WRS reports through Dev-Test-Prod, the BI Manager provides a good export/import wizard. However the SAME information map is being called for this one WRS report. What if the information map is also being moved through Dev-Test-Prod? Take the .srx export file created for the WRS export,
Once you have mistakenly loaded IE 7 and can no longer use the SAS web applications, you'll find that reverting back to IE 6 will take an act of congress. (Really, and you know how slow they are.) Use Firefox and install their IE tab. You can download it from
Once you move to production, you really dont need all of that STP code in the system right? Here are two quick statements you can use to reduce the amount of logging done. options obs=max nosyntaxcheck; %let SYSCC=0; April 2008 UPDATE: Received a question concerning what is impacted by this
Hotfix 4 was made available in June. Don't forget to load it up. http://ftp.sas.com/techsup/download/hotfix/ent_guide41.html#41eg04 The big one that caused problems for me was: "ALERT - SAS® Enterprise Guide® might delete metadata Login objects, causing other SAS applications to fail "
By the way if you want to decode a {sas001} encoded password just remove the prefix and feed it into this page: http://www.opinionatedgeek.com/dotnet/tools/Base64Decode/Default.aspx
Did you know that from Windows Explorer, the specific WebDav Folder can be opened.Just navigate to 'My Network Places' and use the Add Network Place Wizard.
I have emailed this simple code up & down the east coast. My memory isnt as good as it use to be, so I also have a copy nearby to implement when onsite. This updates the metadata within the specified library (and delete tables/info if it no longer exists in
