Go back in and change back to true, and click Ok. Turn the create table to false, click Ok. I’m going to go create a user in the SQL database engine for my new service account, and then go back into the properties. I’d changed the service account on my vm to a dedicated SSAS MD service account (best practice and all), and hadn’t given it login and create table permissions in the source server. Ok, what error? Up two lines is our culprit: “Login failed for user _”. Now we know at least what happened! An error. Starting at the bottom, it says “An error occurred while starting the query log. If you scroll down to the bottom (assuming you just tried to create the OLAP Query log table and it doesn’t work, you should see an entry with the detailed error information: It contains information like the start and stop times of the service, flight recorder start/stop info, some I/O information, and general configuration errors. In it is a simple text file called msmdsrv that shows all of the activity. In the SQL Analysis services install directory, everything that the msmdsrv config file tries to do has a corresponding log entry, located in a log file at $InstallDrive\Microsoft SQL Server\MSAS12.MSSQLSERVER\OLAP\Log (note the 12 is the version number, for 2014. We just need to know where.ĭeep in the depths of Analysis Services there is a file (well, lots of them actually, but we’re looking for something specific here :)). Oh, Analysis Services, why must you vex me so? Fortunately, all of the information Analysis Services is doing with trying to create this table is logged. You go to properties->general, and change the query log create table to true, specify your connection string, give your table a name, and then go check your database. So let’s say you do all this great reading, and want to turn on your OLAP Query Log. I’ve been meaning to blog about this for awhile but have been putting it off, and reading his post motivated me to go actually do it, instead of just staring at the note I have sketched down (thanks Bill!) One thing to keep in mind is that the query log does consume I/O while in use, so be careful about putting too much overhead on your server. Awesome-sauce!īill Anton recently had a really great post about the OLAP query log and how to turn it on and translate it into English (available here). Now when users want to modify groups they can do so easily from within SharePoint, and you’re tabular model can just pull that data through. In the tabular model, create a new connection to an excel workbook, and then paste the filepath you just copied in. Notice that SharePoint files have an extra section in the filepath that must be there in order for it to pull.Ĭopy it, and move over to tabular. You want to grab the location section, and then add in the workbook at the end of it. Right click on the file, and go to properties. When you select that, your workbook will open up in windows explorer and you can then grab the connection string. About halfway across the top of the page, there is an option to “Open in Explorer” Now select the workbook, and go up to Library in the browser options. Once your library is created, upload the workbook. Truthfully, any library will do but long term you’re going to want to restrict this library down to just a few individuals who can access it. □įirst, create a SharePoint library to house you’re workbook. This should be a pretty short post, but it’s really cool so bear with me. Placing them into SharePoint allows us to set security, adjust it in the browser, and just get some other awesome sauce into our model. I did a post a while back about setting up discretization buckets in tabular, but I was recently showing this to a client and the thought occurred to me that we could create a SharePoint library to house these workbooks instead of having to keep them on a fileshare. Additionally, we can now give full control of these groups to business users to be able to dynamically adjust these groups in Excel, and import these into our tabular models. What used to take days in Multidimensional can now be accomplished in just minutes. One of my absolute favorite features in tabular models is the ease in which we can do things like discretization and grouping.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |