Reporting Services :: Plotting Longitude And Latitude With Power View From Multidimensional Source
Sep 2, 2014
I have a SQL 2012 SP1 environment integrated with SharePoint 2013. I have deployed a Multi-Dimensional Cube, due to the need for role playing dimensions and numerous parent-child hierarchies that can't be 'flattened' out easily, it's for this reason that we have gone multi-dimensional, rather than tabular.
The issue I now face is trying to plot the data on a map in Power View. It has to via Longitude and Latitude or easting and northing if possible. I know if I use PowerPivot, I can query the MD Cube, get my dataset and make sure the model views the lat/long as coordinates and this method works just fine - however, it involves an extra step, the end user must pre-build their query in PowerPivot before they can use the Power View maps and adhoc analysis, this can create a lot of back and forth when refining your query or performing additional 'what if' analysis.
When I create the Report Data Source in SharePoint to connect directly to the MD Cube, rather than going through Power Pivot, it's able to connect, but does not recognise the lat and long fields as Latitude and longitude, nor will it let me manually drag it into the lat and long fields on the field list. If I drag them into the 'location' section, it does not plot correctly.
How to get Power View to plot Latitude and Longitude from a Multi-Dimensional Source without having to go through PowerPivot?
I have been plugging away at this for a bit, and I am curious if there are any methods, functions, code, etc. to plug in latitude and longitude coordinates and get the name of a state as a result.
I have tried using the geography type and its "functions" to no avail.
not sure exactly where I should ask this question, but im looking fora database of Australian Postcodes that included thelongitude/latitude.Does anyone know of such a thing? Preferably free...fingers crossed.many thanksjack
I need to be able to take the latitude and logitude of two locations and compare then to determine the number of miles between each point. It doesn't need to account for elevation, but assumes a flat plane with lat and long.
Does anyone have any algorithms in T-SQL to do this?
I've got a working query which returns all leads within a supplied proximity to a city. I followed a tutorial I googled a couple months ago (can't find it now). It works, but would love others to look the query over (provided DDL and sample data) and tell me if it's as it should be.
Two things I don't like about query:
1. I have to do a UNION to another query that retrieves everything that is in the same city in order to have complete results. 2. very slow to retrieve results (> 1 minute)
I have a power view report with some filters. I want some of the Filters to be just Single Value Select Filters like dropdowns instead of Multi-Select ,as multiple selected values can show garbage data. Also it is very inconvenient for the end user to keep unchecking/clearing the previously selected value and then select the appropriate value. Is there a workaround or is it a limitation that has yet to be addressed???
I have a couple of Power View reports that I cannot enable the data refresh schedule for. I cannot pinpoint what caused the schedule to stop working but the scheduled data refresh for these reports used to work and now they don't. Every time I try to enable a schedule the page submits and it seems like everything worked (no errors). However, when I go back to the schedule page for the report the Enable checkbox is unchecked. There are other Power View reports that are scheduled and running just fine. The only error I can track down in the SharePoint logs is this:
Failed to remove workbook tracking handle from collection for workbook
I've tried making a copy of the file and re-uploading with a different name but nothing changes. The user would really rather not recreate the report from scratch.
I am trying to show images in a product listing in power view.I work with an excel 2013 desktop version based on an office 365 pro account.I did the following steps:
import of an excel file with an article list via power query and loading the data to the data model import jpg images from a folder via power query, setting content as binary type and loading the data to the data modellinking both tables in power pivot--> manage via the image namesetting the table behavior for the images table under power pivot --> manage --> Advanced (e.g. Default Image: Content)opening power view and building article cards with article number and imageProblem: only a camera icon shows up in power view
Is there a solution with a desktop version?Can I use my Office 365 Pro account to make it work? How?Why is there no solution showing images in a pivot table?Link to Dropbox with power pivot files
Getting Cannot PIN SSRS Chart...Server Error: The item "Dashboard deleted 9e0c7443-406d-4435-aaf3-8c7d5a47b7db" cannot be found. (rsItemNot Found).Yet, the list in the drop down populates the list of dashboards from Power BI (loading).Dashboard in Power BI works fine.
I have several reports in a Power View Gallery. In Gallery view, most of the reports show the "Open New Excel Workbook", the "Create Power View Report", and the "Manage Data Refresh" buttons on the right side of the report list. Why would some reports not have these buttons available? In the attached image you can see one report with the buttons and one without the buttons.
I'm a relative newcomer to Power View. I've been playing with charts and have been struggling to combine both line and bar on the same chart. It would appear this functionality is not available. Considering this is basic functionality when it comes to charting, how to achieve this....
My requirement for the parameter is multivalue parameter with a text box. for example when user enters aa15 it need to include product aa15. when the user enters aa15, aa16, zz15 than it needs to include all the three products. the last case is when the user enters AA** than i need to inclued all the products start with AA. when i use default multivalue parameter with data source analytical services than i am getting a drop down box. I dont want that. I need a text box where user can enter the value. 1. In sql we have a like key word to query . for example select * from product where product like "AA%". what is equavalent mdx query to get such results ? 2.How to impliment the multivalue parameters without using dropdown box?
Hi all, I am in a situation where some reports were developed by a colleague who left the company. The reports were published on the server but since the code behind the reports was deleted inadvertently. We don't have documentation about them.
My questions are:
is there a way to recover the source code?
is there a way to produce a report showing a list of the reports and the underlying data straucture/stored procedure, even in cases where the RDL is missing (i.e. from the published report)? Many thanks in advance Massimo
I have created an SSIS Package which provides Data to a DataReaderDestination. Next I have uncommented SSIS support in rsreportserver.config and rsreportdesigner.config
After that I have set up a shared Datasource in ReportServer and created a Report using that DS of type SSIS.
/FILE D:ETLReportingDataService.dtsx
When trying to see the report using http://localhost/reports I get a message that tells me that the package fails to execute. It does so well when debugging, so my guess is that there is some security issue.
It also does not work in preview dialog in VS. The error message there is "Cannot read the next data row for the data set dsSSIS. Object refernece not set to an instance of an obj.
I haved tried several sec. config-scenarios for the shared datasource. No change
I am using sql 2005 std, march sp1 ctp
Does anyone have a clue what could be the cause of my problem
I want to run SSRS report directly by connecting Excel as a data source. The report runs properly from SSDT, but when it is run from Report manager, some users cannot access the Excel connection and the report execution fails. I am using SSRS 2012 and Excel 2010.I have created the ODBC data connection in SSRS and when I use 'Windows Integrated Security' option for credentials, the connection gets successful. But the problem is that all users does not have permissions to access the Excel inline, but they should get the report working.How can I store the credentials to access the Excel in SSRS with a specific username and password?
I have set up a report on reporting services and deployed it on a server. (server A) The data comes from 2 databases - one on Server A and one on server B
I can view the reports when logged into Server A, but if I try to view them from a networked PC I get the following message:
An error has occurred during report processing.
Cannot create a connection to data source 'byvshs01'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Byvshs01 is Server B.
However, if I remove the data from server B from the report, I can view it ok. So it seems you can view data from a DB located on the server that hosts the reports, but not if the DB is located elsewhere.
An error has occurred during report processing. (rsProcessingAborted)...The execution failed for the shared data set 'DataSet1'. (rsDataSet ExecutionError )...Cannot create a connection to data source ' Data source for shared dataset'. (rsErrorOpeningConnection)...the above error message I get on the published report, but everything works fine when I do a preview in Visual Studio.How can I see exactely what is wrong?
When Datazen caches a data source, it sometimes says that the data was truncated. What factors are involved in the truncation and what I might be able to do to expand the size of cached elements to avoid truncation? My only current solution is to make the data source "Real Time" rather than cached.
I have a question about ssrs security. In report manager I have set a list of users as browsers, and the builtin administrators are content manager in the parent folder where reports are. A user that is not an administrator and neither a user I added, has access to reports.
I'm thinking this person is having access because the data source of the reports use a administrator account to connect to the analysis services using the option Credentials stored securely in the report server with the 2 checkboxes marked (use as windows credentials when connecting to the data source and impersonate the authenticated user).
I simply marked this option because SSRS is in 1 server and SSAS in other and I think kerberos need to be configured and I haven't looked into it, but I think the report access is separated from the data source.
