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


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

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 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

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 :: 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 :: 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 :: Power BI Analysis Services Connector - Remote Server Returned Error

Mar 5, 2015

I have, a SSAS 2012 tabular instance with SP2, there is a database on the instance with a read role with everyone assigned permissions. When configuring the Power BI analysis services connector, at the point where you enter Friendly Name, Description and Friendly error message, when you click next I receive the error "The remote server returned an error (403)." I've tested connecting to the database from Excel on a desktop and connect fine.I don't use a "onmicrosoft" account so don't have that problem to deal with.

We use Power BI Pro with our Office 365. As far as I can tell that part is working ok as I pass that stage of the configuration with a message saying connected to Power BI.The connector is installed on the same server as tabular services, its a Win2012 Standard server. The tabular instance is running a domain account that is the admin account for the instance (this is a dev environment) that account is what I've used in the connector configuration. It's also a local admin account. There is no gateway installed on the server.

View 10 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

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

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

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

Sql Server Reporting Services And Analysis Services?

Jan 27, 2004

Hi

What is the diff between the above 2?

Thanks.

View 1 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 :: Cube Needs To Be Deployed From VS After SSIS Analysis Services Processing Task Completes?

May 13, 2014

I have a cube that we are processing nightly via an Analysis Service Processing Task in SSIS.  In order to increase the performance of the processing time, we elected to use a lot of rigid dimension attributes, and do a full process of everything in the SSIS task.  The issue that I am having is that after that task completes, I need to go into Visual Studio to deploy the cube becuase we are unable to browse or use the cube.  This issue seemed to start once we changed the SSIS Analysis Service Processing Task to do a full process on the dimensions, rather than an incremental.

I would expect that once development is done, and it is processed and deployed, that is it.  My thinking is that the SSIS task should just update the already deployed cube,

View 2 Replies View Related

Analysis :: How To Right Choose Key Column In Mining Structure For Microsoft Analysis Services

Jun 12, 2015

How to right choose key column in"Mining Structure" for Microsoft Analysis Services?
 
I have table:

"Incoming goods"

Create table Income (         
ID int not null identity(1, 1)            
[Date] datetime not null,             
GoodID int not null,               
PriceDeliver decimal(18, 2) not null,               
PriceSalse decimal(18, 2) not null,               
CONSTRAINT PK_ Income PRIMARY KEY CLUSTERED (ID),             
CONSTRAINT FK_IncomeGood foreign key (GoodID)  references dbo.Goods ( ID )            
)

I'm trying to build a relationship(regression) between “Price Sale” from Good and “Price Deliver”.But I do not know what column better choose as “key column”: ID or GoodID ?

View 2 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

Reporting Services : Report Using Two Datasets From Two SSAS Cubes

Mar 5, 2008

Hi,

I would like to build an SSRS report from two different cubes (SSAS 2005). These cubes are contained in two different SSAS databases.

To do this, i created a dataset for each cube throught MDX expressions.
These datasets use common parameters defined in my report.
Thus, i try to integrate in my report chart datas from the two datasets, but my chart only target one dataset.

Is it possible to create a kind of dataset view to join my two datasets ?
Or is it possible to join the cubes from two different SSAS databases in an MDX expression to put all my datas in a single dataset ?

thx for your help.

Zohir

View 3 Replies View Related

Analysis Services Server Not Available

Dec 21, 2004

Hi
I installed Analysis Services yesterday and was building some test cubes from our receipts data, today, when I tried opening my cubes, it appears that my Analysis Server (on local machine - laptop) is not available giving the error message of :

"Unable to connect to the registry on the server FJKILKEN-MOBL, or you are not a member of the OLAP Administrators group on this server"


I have shut-down/restarted, and then checked that all appropriate services (SQL server, OLAP server etc) are running which they are any idea on what the issue could be?

Thanks a lot

Fergal

View 4 Replies View Related

SQL Server Analysis Services

Jul 20, 2005

Hi All,When I try to run the SQL Server Analysis Server, I get the followingerror:"Cannot Open Connection to Analysis Server <server name>.Network error(during operation)".I have not had any luck with SQL Server Books online with this issue.Would really appreciate any help leading to resolving this issue.Thanks,-Sandeep Madduri

View 1 Replies View Related

SQL Server Analysis Services 2005

Jun 13, 2006

hii
what is SQL Server Analysis Services 2005 ??
thank you

View 1 Replies View Related

Analysis Services Archiving Is Working On One Server

Oct 5, 2001

Hi,

I am able to archive the Analysis Services db's using the msmdarch on one server but not the other server. (It is working in the Test environment but not the Production environment.) Here are the details:

Both servers are SQL Server 2000 sp1.
I compared sp_configure and both servers have the same settings.
The Production server is clustered and the Test Server is not clustered.

I can archive in TEST using the following:
- From Analysis Manager
- Using the msmdarch command from a command prompt
- From a scheduled job using the "Operating System Command" Type from a job step entering the msmdarch command in the Command box.
- Using the msmdarch command with xp_cmdshell within Query Analyzer and from a Stored Procedure.

I can archive in PRODUCTION only using:
- From Analysis Manager
- Using the msmdarch command from a command prompt
** It does not work from a job or from Query Analyzer

I have checked the permissions of the SQL Server Agent account on both servers and they are identical with sa rights and a member of the OLAP Administrators group.

Does anyone have any thoughts on what could be causing this?

Thank You

Michael

View 4 Replies View Related

Error When I Try To Register A Server In Analysis Services

Oct 13, 2004

Hi,

When I try to register a server in Analysis Services I get a error saying 'Automation error' and I also get a message saying Unable to open Registry Key 'SOFTWAREMICROSOFTOLAP ServerOLAP Manager'

Can someone please help.

View 2 Replies View Related







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