![]() Ok, once you’ve loaded the AdventureWorks 2012 DW database and the MOLAP cubes from Codeplex into SQL Server, you should see them appear in your SSMS: Instead, the ssas2mondrian utility will take your model outline of dimensions, measures, expressions, attributes, hierarchies and measure groups and convert them to Mondrian descriptors and names, but leaving out decisions about conflicts and conversion gaps in the hands of the BI developer. You’ll need to become familiar with the Mondrian schema and MDX differences because we don’t have a complete migration tool that can do it all for you. Instead of rewriting the details of some of the primary differences between the 2 engines that you need to be aware of, I’m going to just link you back to my last posting on this topic at KromerBigData. So basically, instead of recreating a new OLAP model in Pentaho’s Analyzer, we are going to just migrate as-is from SSAS. The tool needs more features and error catching, so please contribute your ideas back to the source project! The full source code and C# project is available on GitHub in case you want to add more to it, have a look around, etc. Make sure you also download the SQL Server 2012 JDBC driver and the tool that I built to help you migrate your online SSAS cubes from the SQL Server Analysis Server to Mondrian XML schema output files using AMO here, called SSAS2MONDRIAN. And here is the Codeplex link for the open source download of the Adventure Works SSAS 2012 MOLAP cubes that we’ll use for this demonstration. In case you didn’t already do so, make sure you go here to download the evaluation of the Pentaho Business Suite here. Once you are converted over to the Pentaho platform, then you can start playing around with Pentaho analytics and manage the new version of the cubes in Pentaho. This way, you can use the modeling tools that you are already familiar with (i.e. In this entry, I’m going to show you how you can move over to the Pentaho BA Suite quickly by getting started with your existing SSAS cubes, such as the Adventure Works sales cubes, by migrating them pretty much as-is to the Pentaho ROLAP engine called Mondrian. I tried both in BIDS and in SSMS but i don't seen excel icon to analayze the data, please need help.In the 2 previous blog entries about recreating the SSAS example cubes for Adventure Works sales BI on Pentaho, I focused on generating new departmental-sized ROLAP cubes through the thin client Auto Modeler tools here & here. As in this article i do not have the excel option in my SSAS. What i couldn't get is i can see the data for the newly added field under the browser tab but in excel the filed is not showing any values other than the blanks. Recently the user wanted to see an extra field in the ddrill down report, so i went into the ACTIONS and added that field. I have a report and when you click on a particular field it takes you to drill down report. Wednesday, 10:29:26 AM - Daniel Calbimonte Thanks, for some reason i deleted the dimension and recreated the dimension and added it to the actions and now i can see the data in the excel as well. Is there anything in excel or add on to accomplish this? In other word, I want to email out an excel report with two columns (Internet Average Sales amount and Internet Average Unit Price) in it to other people but I don't want recepicients to have connection to the SSAS or have a office cube data file sitting somewhere on their local machine. Is it possible to share only the "view" of the excel report without the SSAS connection? (disclaimer: yes, I work for DevScope very closely to SmartPivot team ) ) You can check my blog here for more info / Lots of extra features, including full instant search, saved filters,faster table reports & several others. Have to mention our addon for Excel, Analysis Services/PowerPivot: SmartPivot. Also a big fan of Olap Pivot table extensions :) recomend that! Very good overview on Excel, OLAP & Analysis Services. And in ssms, its connecting to Analysis services (local). "UNABLE TO CONNECT TO DATA SOURCE.REASON: UNABLE TO LOCATE DATABASE SERVER.VERIFY THE DATABASE SERVER NAMEYOU ENTERED IS CORRECT,OR CONTACT THE DATABASE ADMIN FOR HELP"Īfter this error, nothing is happening. , and selecting windows authentication, its showing an error, which says Please check this link:Īfter writing the server name as. ![]() ![]() How can find my servername? or what is wrong ? Could you please help me
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |