09-11-2014 12:35 PM
HI SAS BI Folks,
SAS BI reporting problem
The Business users or Information consumers at my organization would like to view dynamic reports on the web at their desk without having to learn any SAS for their decision making. In our SAS Environment, we do not have Information delivery portal. At our IT centre, we are stuck in figuring out the right SAS BI component to perform the task. We have been given a report style template in an excel spreadsheet and have been told that's the format and style they want to see using web and it has to be made dynamic.
Would the ideal solution be Stored processes(in EG or DI studio) or WRS or something else? If you can suggest me the right technique, can you please support in explaining me why?
09-11-2014 02:15 PM
I think you need to detail your requirements to get more valuable advice.
One thing that often happens is that user tend to ask for standard reporting, but in the end they have very specific requirements that they think needs be fulfilled.
Your main SAS options are:
With this, there is an add-in for MS Office which initially came with Enterprise BI Server, but can be connected to VA as well. Here you can open data, StP, tasks (wizards), OLAP cubes and reports.
Take a look a the SAS product pages, there are some on-line demos available as well.
09-11-2014 02:54 PM
My requirement is for a Banking and financial services project and the objective is Financial consolidation report. I guess it's pretty much standard yearly reporting and monthly reporting. Precisely speaking summary reports, pivot tables, and some listing. Does that really help Sir?
The front end users want to just click and view at ease. And my job at the back end is to create the whole thing if you know what i mean.
09-12-2014 06:28 AM
My advice is contact a SAS sales representative to get help on the user requirements, and have them suggest a package for you. Optionally contact a more independent consultant so you can feel that you are entirely in the hands of an Institute sales person.
09-12-2014 04:16 AM
Not really help allaluiah, There was a complete serie blogs on bcbs239 (basel III) http://blogs.sas.com/content/sascom/2014/06/23/series-bcbs-239-principle-12/
You are only mentioning the "financial consolidation report", with hat I am finding http://www.sas.com/resources/factsheet/sas-financial-mgmt-factsheet.pdf
Not knowing if this is what you want going for an investigation on SAS docs http://support.sas.com/software/products/fm/index.html
The documentation is closed but the system-requirements can be seen. choose Linux and win-64 and all the products in that are shown.
It is the whole BI/DI suite metadataserver olap server midtier, ETS, forecastserver, webtier, portal ESri, EGuide, AMO. (forgot to mention SAS-VA)
That is quite a lot.
What I am not seeing is enterprise miner, text miner. That is more predictive analytics for marketing purpose. IML is not there and advanced Analytics also not.
That is also quite a lot.
A solution is more thinking as a solution. The components are still there but not assembled separately with the license.
Compare to the automotive. You are buying a family-car or one for business transport. You do not split them in many parts to compose something on your own. The integration and support for your business is your local question to solve not the one of automotive manufacturers.
Of course you can still build it on your own or compose something on your own. That is your choice.