Data Cubes Using MS Analysis Services

Jan 6, 2006

I need to use cubes in VS 2005 web project. I have no clue how to create cubes or use them in my web page. I am familiar with Reporting Services but not cubes.

thanks in advance!

 

View 4 Replies


ADVERTISEMENT

Use Cubes From Analysis Services 2005 To Analysis Services 2000

Oct 17, 2007

Hi,

I have some questions about SQL Servers 2000 and 2005 compatibility.
In my configuration I have to use both servers.
The cubes are stocked in 2005 server.
May I transfer from 2005 to 2000 Analysis Services the cubes?

If yes, what is the procedure? The result of migration is the same in the two different versions?


If not, how can I solve this problem?

Thanks in advance.

View 3 Replies View Related

SQL Server And Analysis Services (Cubes)

Aug 7, 2002

Hi, i want to back up my SQL Server database and the cubes i've made on the anaysis services


i have backed up the SQL server database wihtthe wizard, and i do not know how to back up the cubes..

Is it possible, and if so, HOW??

thanx
reply @
nouman@emirates.net.ae

View 1 Replies View Related

Analysis :: Data Encryption For Cubes

Apr 30, 2015

One of my client requires TDS for all databases. My BI product has reports with OLAP Cube as data source. 

How about using BitLocker for the HDD where the abf is physically located.

View 6 Replies View Related

Analysis :: How To Extract Data From SSAS Cubes Into A Table

Jun 19, 2015

I need to extract data from SSAS' cubes into a SQL Server table.

I already read examples using Linked server (with openquery), SSIS, etc. However, the result always return as many columns per dimension as levels. I need to extract all members of a dimension in a column. E.g., when excecuting the following MDX query in Adventure Works 2014:

select [Measures].[Sales Amount] on columns,
       Non Empty [Date].[Calendar].members on rows
  from [Adventure Works]

I would like to get this result (MDX query in SSMS), but with keys displayed intead of names:

But I get this (MDX thru openquery or SSIS):

View 4 Replies View Related

Transfer Data(Cubes+virtual Cubes) From Sql2000 To Sql 2005

Jun 6, 2006

Süleyman writes "I want to transfer databases with cubes and virtual cubes from SQL 2000 Analysis Server to SQL 2005 SQL Express.

1.how i can transfer the cubes?

2.how i can transfer the virtual cubes?

3.Why i see the tables(saw)and the cubes in SQL Managment only under Tables together and nothing under cubes?

Please help me
many thanks

Süleyman from Germany/Frankfurt am Main"

View 1 Replies View Related

Analysis :: Create Analysis Services Project In Visual Studio 2012 Data Tools?

Feb 18, 2013

It is possible to create Analysis Services project (*.dwproj) in Visual Studio 2012 Data Tools?

View 5 Replies View Related

About Cubes In Analysis Manager

Feb 13, 2003

Hi all,

I am working on datawarehouse
using sql server analysis manager.
I created a cube ..that is working fine
but now i have to distribute to end users
so how to do it and how many ways we can do that

1)can we make that .cub file
2)how can give access to endusers
without giving access to database
3)how to host a cube and access from
excel or any other software

Thanks
J

View 6 Replies View Related

Analysis Service: How Can I Process Cubes?

Oct 11, 2004

how can I process and update cubes automaticly every night ?

Thanks

View 1 Replies View Related

Analysis Serices, Cubes And Access

Jul 20, 2005

How to get data from cubes in analyses manager to MS access using forexample ODBC ? Does existe any other posibilities to get data from cubesdirectly to the accees ?thanksKris

View 1 Replies View Related

Analysis :: Copy Roles Between 2 Cubes

Jun 5, 2007

I work with 2 cubes on live and one for development. I've set the roles in the live cube (using SQL Server management studio). If i go to the design mode of the cube the new roles are not there, so deploying the cube will not update the development cube with the roles. How one can easily copy roles between cubes. (adding them manually would be a lot of work because there are quite a lot of different roles).

View 5 Replies View Related

Analysis :: Dynamic MDX - Select From 2 Cubes

Sep 2, 2015

I am trying to select from 2 cubes. in one condition - select .. From CubeX, and in sec Condition Select .. From CubeY.

I tried to put the name of the Cube as parameter:
SELECT ...
FROM @CurrentCube

in ssrs source and i got the message:
------------------------------
Failed to parse the query to detect if it is MDX or DMX. Error: 'Query (148, 6) Parser: The syntax for '@CurrentCube' is incorrect.' (MDXQueryGenerator)
------------------------------

Also tried to get the name of the Cube as Member (I have a property with the name of the cube),and than using the member to the select :

WITH MEMBER [CurrentCube] AS
...[dim name].CURRENTMEMBER.PROPERTIES("Cube")
SELECT ...
FROM [CurrentCube]

It didnt work too.. Is it Possible at all make the Cube-name dynamic?!

View 5 Replies View Related

Analysis :: Partition Process Error In One Of Cubes

Jun 2, 2015

I am getting partition process error in one of my cubes. I don't have any clue what could be the workaround with this.

View 2 Replies View Related

Analysis :: How To Union 2 MDX Query Results From 2 Cubes

Nov 12, 2015

How can I UNION two MDX query results which are deriving from 2 cubes?MDX queries will return same ROW information and only Measure names will be different.

View 8 Replies View Related

Analysis :: Creating Cubes In SSAS Using Various Tables In Excel

Jun 29, 2015

I'm exploring creating local cube files, .cub from an excel sheet with tables.Would SSAS be able to create one cube from taking data from a 1 way table (A, B, C), a 2 way table (AxB, BxC, AxC) and a 3 way table (AxBxC)?

View 4 Replies View Related

Analysis :: Create OLAP Cubes Using NAV 2009 SP1 Database

Feb 13, 2012

I am attempting to create som OLAP cubes using the NAV 2009 SP1 database. I am using Jet Enterprise with TimeXtender4 to build the cubes.

View 5 Replies View Related

Analysis :: How To Use Stored Procedure In SSAS To Combine Result From More Than Two Cubes

Jul 15, 2015

I have two cube and i would like to get data from both cube and combine the results from both cubes to get final result to display result in SSRS reports like we can do in Stored procedure using temporary tables/Joins.Is there any way in SSAS to combine the data from multiple cubes? Data needs to be retrieved from the cubes based on the user inputs.

View 3 Replies View Related

Analysis :: Excel Freezing When Interacting With Microsoft Dynamics AX Cubes

May 7, 2015

I am running into a problem where Excel 2010 is freezing when I try to work with data coming from a Microsoft Dynamics AX 2012 R3 pre-built cube.

What is happening is that when I go to add a second dimension to my pivot table, excel locks up and becomes completely unresponsive for at least 2 hours.  If I add the dimension to the table before the measure though, everything is fine.

For Example, I am trying to build a sales report with the product name and customer name as dimensions, and Sales as the measure. If I add the product name to my pivot table as a column and then sales as a measure, Excel will freeze when I try to add the customer dimension. However, if I add both dimensions to the pivot table first and then the measure, Excel seems to work fine.

View 2 Replies View Related

Reporting Services :: Error When View Reports Or Manually Processing TFS Data Warehouse And Analysis Services Cube

Apr 24, 2015

I am trying to configure the reporting for TFS using SQL Server. But I get following error when viewing any report:

So I try to manually process the cube to check if it works. I am following this article: [URL] ....

When I click on GetProcessingStatus and invoke it (with last field set as TRUE) I get following error:

How to resolve this issue and be able to see the reports.

View 5 Replies View Related

How To Access Analysis Service 2005 Cubes Through Normal Stored Procedure

Apr 2, 2007



Hi,



Can anybody tell me How to access Analysis Service 2005 cubes through normal Stored Procedure.



Basically can write a stored procedure that we normally write in database service and use it access the Analysis Service 2005 cubes.



Is it possible



Regards,

gokul

View 1 Replies View Related

Analysis :: Grand Totals Not Adding Up In Power View On Molap Cubes?

Nov 12, 2015

My Power view reports do not show the grand totals correctly.  I think my issue relates perfectly to [URL]. However we have updated service pack 2 on both the sql data warehouse and the ssas box.  They are 2012.  However the power view is still incorrect.  Pivot tables seem to work just fine.  In AS I have a 2 separate measure groups that has a total count.  I then use mdx to bring those two together.  Something I have done many times in past with as 2008.  My mdx looks like this below.  I then hide Total Count EC (from measure group 1) and Total Count SF (from measure group 2). This way I have 1 total count value and they can use another dimension to see the two separate if needed. 

CREATE
MEMBERCURRENTCUBE.MEASURES.[Total
Count New] AS
//
([Measures].[Total Count] + [Measures].[Total Count SF]),
DISPLAY_FOLDER
=
'Totals', 
ASSOCIATED_MEASURE_GROUP=
'Report',
FORMAT_STRING
=
"#,#0",
VISIBLE=
1;

The measure Total Count EC works just fine but the Total Count (MDX) does not .  All in Power Pivot works fine but in Power View the grand totals are not correct.

View 3 Replies View Related

Reporting Services + Analysis Services Data Source

May 15, 2007

Hi all,

Till now all the reports for our application was created in Reporting Services 2005 with SQL Server Database(OLTP) stored procedures.

Most of the reports take 10 to 15 report Parameters and all are multi valued.



Now because of the slow response time,we have decided to use OLAP cubes data source. We have created the OLAP cube in Microsoft Analysis Services.

Can someone tell me how to use the report parameters to query the Cube.

Any links,books for reference would be of great help..



Thanks,

Looking forward to your replies

View 3 Replies View Related

Analysis :: Tracking Information About No Of Connections Made To SSAS Cubes Through Excel Files

Sep 29, 2015

Is there any way to track the information about the  connections to SSAS cubes through local  Excel files (BI usage).

OPreviously, we are tracing the information about the BI usage through the BI SharePoint site. Now we want track the users who are using through local excel files .

View 9 Replies View Related

Analysis :: Can Applications Connect To SSAS Tabular Mode Cubes Through ODBC Drivers?

Aug 26, 2015

Can applications connect to SSAS Tabular mode cubes through ODBC drivers? I have been asked the question specifically regarding SAS, and I can see (for example) SAS Enterprise Guide has the ability to connect to sources via ODBC, so I now need to find out if there are such things as ODBC divers for SSAS (specifically Tabular).

View 3 Replies View Related

Help Loading Data From Excel To Analysis Services

Jul 20, 2005

I have a 40 MB database in excel format.I need to use it in Analysis Services, I imported the data by DTS (DataTransformation Services), everything is working I can see the database,but I can't load it in the analysis services.I have to construct a cube but I can't see the database in any way Itried.Thank youI hope my message is quite clearHope to find somebody that can answer me in Italian, but English is goodas well.

View 3 Replies View Related

Analysis Services 2000 (data Mining)

Sep 8, 2006

i create a model mining

CREATE MINING MODEL [a'S]
( [Cusid] LONG KEY ,
[Orderdetails] TABLE PREDICT ([Productid] LONG KEY )
) USING Microsoft_Decision_Trees

i can show for customer some products other when he choise a product.

ect: he choise A, i show he B, C, D ....

but for that, i must know his cusid.

now i want show B,C,D when one man choise A ( i don't know his cusid). how i do that.

( i'm using sql server and analysis service 2000)

View 4 Replies View Related

Analysis Services Connection From Data Source

Aug 28, 2006

Hello everybody.

I want to perform a Analysis Services Processing Task using a connection manager created from a Analysis Services data source. I create the data source using the Oledb provider for Analysis Services 9.0, and it works fine. Then I create a connection manager using the "New connection from data source" option, and it seems to create it ok.

The problem is that I can't then asign this connection to the Analysis Services processing task. I get the error:

"Connection Manager MyConectionManagerFromDataSource is not a Analysis Services Connection Manager"

However, if I create directly a connection manager using "New Analysis Services Connection" it works fine.

Is it at all possible to create a Analysis services connection from a Data Source to perform a Analysis Services Processing Task?

Thanks in advance,

View 4 Replies View Related

Analysis Services: Data Source Provider Error

Apr 10, 2006

Trying to go through the Analysis Services tuturial. Logged in as Administrator on a 64 bit W2K server. SQL Server 2000 AS and SP4.As I come to the Design Storage step I get a message sayingData source provider error: ; Time:2006-04-10 19:51:47There are no further details given and the Event Logger has nothing.Grateful for any help.Screenshot: http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem.pngAnd the version Screenshot:http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem2.png

View 7 Replies View Related

Where Can I Get Data Mining, Analysis, Integration And Reporting Services?

Jul 26, 2007

Hi,
I'm trying to learn about analysis, integration and reporting services. I have install SQL server 2005 management Studio Express. but I cant find these in the Start menu as mentioned in the tutorial Click Start > SQL Server 2005 > Business Intelligence Development Studio.(for reporting services).
what do I need to do? Please help me.

Regards.

View 1 Replies View Related

Analysis :: ASMCD To Sync Cubes From Cubebuild Server To Reporting Server

Jul 7, 2015

we are using ASMCD to sync our cubes from a Cubebuild Server to a Reporting Server. We migrated some days ago from 2012 to 2014. We are also using rel. Engine with StoredProcs for calling and executing xp_cmdshell for the Ascmd.Actually all works fine for our smaller cubes. For the bigger one we got the following issue. The cube is being synced but the proc delivers error.In the log we found this entry:

(7/7/2015 11:26:22 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.dbLocal Controlling Cube.0.cub' could not be deleted. Please check the directory for permissions.
(Source: ?D:SSAS_LOGmsmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210020)
(7/7/2015 11:26:34 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.db' could not be deleted. Please check the directory for permissions.

[code]...

View 2 Replies View Related

Unable To Generate Model Off Of An Analysis Services Data Source

Feb 21, 2007

Hello,

Our company is doing some basic research into using analysis services as a solution for our customers. I've taken our database and built an analysis services project in BI Studio and deployed it to Analysis Services on my local machine I connect to Reporting Services in Management Studio, create a folder for the cube, give my Windows user acct. Content Manager permission, create the Data Source (conn string = "Provider=SQLNCLI.1;Data Source=(local)SQLServer2k5;Integrated Security=SSPI;Initial Catalog=STI-PDB" -- copied from the Analysis Services project in BI Studio), and go to "Generate Model". What I get is an rsModelGenerationError, sub [Create Perspective From Cubes] with a connection issue at the base:

Either the user, <computername>Thomas, does not have access to the STI-PDB Database, or the database does not exist. () (Microsoft SQL Server 2005 Analysis Services)

Now, in the Database Engine, my Windows account has the db_owner database role for STI-PDB and it's default schema is dbo, which all the objects are created under. What am I missing here?

View 4 Replies View Related

How To Connect To Analysis Services With Excel 2007 Data Mining Add In?

Jan 18, 2007

I downloaded a trial version of office 2007 and the data mining addin. I do not have an automatic connection to Analysis Services, so most functionality does not work. Is it possible to configure a connection with a trial version? If so, does anyone know what the server name is and how to configure it?

View 14 Replies View Related

Licensing Of Data Mining Tools With SQL 2005 Analysis Services

Oct 25, 2006

A rather dumb question but I've installed an evaluation copy of SQL 2005 on my machine and a colleague would like the Analysis Services Data Mining capability on his machine (without the eval SQL Server).

Is there a license associated with such an installation when we buy 2005 or does it fall under client components which can be installed on any number of users machines?

Matt

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved