Stack Overflow
Stack Overflow

Questions tagged [datasourceview]

10 questions
4
votes
1 answer

SSAS cube: Error while opening a data source view

I got an SQL Server 2012 evaluation edition installed in my Windows 7 laptop. I am trying with an SSAS project. The data source is a database in an instance in the same machine. I get the following error immediately after creating a Data source…
Jithin Shaji
  • 5,893
  • 5
  • 25
  • 47
2
votes
0 answers

Error when adding Analysis Services Data Source View from c# code

I want to create an Analysis Services database, datasource and datasource view from c# code. Everything seems to be working fine until I add a mining structure and models and try to process the structure, then i get the following error: Errors in…
cmperezg
  • 145
  • 11
1
vote
2 answers

Asp.net Datasource - view sql data by lookin at datasource object?

Is there a way to view data that is returned from db by looking at DataSource or DataSourceView object in codebehind? I'm trying to view DataSourceView in debug but I don't see the data returned.
dev.e.loper
  • 35,446
  • 76
  • 161
  • 247
1
vote
0 answers

In a MS SSAS Project, creating a Data Source View over Npgsql (PostgreSQL) Data Source produces 42601: syntax error at or near '['

I'm trying to create Data Source View in a Multidimensional SSAS project using MS Visual Studio 2017 with SSDT installed. In the Data Source View Wizard, I select my Npgsql (v. 11.00) based datasource connecting my PostgreSQL 10.5 I created before.…
Jan Lender
  • 48
  • 8
0
votes
1 answer

View from SSAS Data Source View not shown under Cube partitions

My problem is, that I created some SQL views in a database to create partitions in a cube. For example: View1_Table1_Year2000 View2_Table1_Year2001 ... Source for the Views is "Table1" filterd on different years. I added the views to the DSV and…
user2961680
  • 1
  • 3
0
votes
1 answer

Can a SSAS Data Source View be pointed to a different server data source?

We are doing a parallel migration of our SQL Server 2005 database, cube and SSIS packages to 2008 R2. The cube successfully migrate to 2008 R2 via the BIDS migration wizard. However, the Data Source View is still pointing to the old server. Do…
SidC
  • 3,175
  • 14
  • 70
  • 132
0
votes
2 answers

SSRS Data Source View Parameter in Function

IN SSRS (SQL Server 2008 Standard), I have a table valued function with one input parameter. In attempting to create a new Named Query in the data source view, I have entered: SELECT Family, Steet, userName FROM …
stonefree
  • 400
  • 1
  • 3
  • 8
0
votes
1 answer

SSRS one model returns data another does not

I have one report model based on a data source view. I also have a report running a query which returns some data. I have added a field in the database in some table. I have refreshed only that table in the dsv (by deleting it and adding it back and…
Alex
  • 157
  • 8
0
votes
1 answer

what is the easy way to compare cube data with that of data mart?

I was trying to compare with the cube's data with that of data mart using TSQL query. It s hard for me to find where the columns used in the cube are coming from. Because the columns used in the cube are coming from data source view, but how do I…
sagar
  • 159
  • 3
  • 13
-1
votes
2 answers

SSAS dimension from two DSV

please, can I create a dimension from two different Data source views in one cube ? I had one AS DB in it one dsv and one cube now I want create another cube based on other dsv but with same dimension date used tables are wuth same structure joined…
nikos
  • 11
  • 2