.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Determining the status os the Batch job that process SSAS Cubes

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi All, I have a cube and that is processed through a batch job. The problem I am facing is there are many packages which are calling this Batch job to process the cube. Is there a way to determine the state of the job before the packages call this batch job to process the cube. And in which database can I find all the information about the jobs on the server. Thanks for your help. Vineeshvineesh1701

View Complete Post

More Related Resource Links

How to process just one cube in a solution of three cubes inside BIDS SSAS

Hi, I have a BIDS Solution with three cubes...I want to make a full process of just one of the cubes, but If am doing just one, the other cubes comes unavailable... How can I process just one without affecting the other ones? Thanks!

Process cube - other cubes get processed

When I process a single cube other cubes are getting done as well. Am I right in assuming that is because they share dimensions ?

Errors attempting to process SSAS Cube. I get Either user does not have permission to create a new o

Hi All, One of my production server deployed cubes i am not able to process the cube.When i tried to process the cubes i will get an Error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Either the 'NA\gsad478' user does not have permission to create a new object in 'JNJAUSYSVR01', or the object does not exist.  (Microsoft.AnalysisServices)   Over the source server i do have sysadmin access and also  i have added read only role of particular cube. I right click on the database and tried to create new database of SSAS that also thrown with same error. Please help me in this regard.   Thanks, Gangadhar

SSRS Report based on SSAS Cubes doesn't show NULL values correctly

I have a SSRS report which is based on an SSAS Cube. In the Cube the formating of numeric fields that NULL values are properly shown as NULL values. In the Cube Browser and Excel this is shown correctly. However when I design the report already the query against SSAS shows these fields as "0" instead of NULL. Is there a way to fix this or is this a bug ?  

SSAS cubes with shared dimensions

Hi, I'm working on a fairly complicated SSAS project at the moment:  - SSAS provides information to 6 teams, which I have modelled as 6 separate cubes.  Each team should not be able to access the other team's cubes.  - Each cube has 4-5 measure groups, with no cross-over with other teams.  - Each cube has approx. 8 dimensions, 5 of which are conformed dimensions, common across all cubes, and 3 dependent on the specific measure groups.  - Each cube has a couple of perspectives set up to simplify the presentation.  - The underlying data comes from a single data warehouse database.  - It's possible that another team may shortly want to develop their own cube.  The data would be completely separate however they would need to use the same conformed dimensions as above. I'm at the starting stage, so I have set up one cube along these lines and am about to work on a second.  My question is, is this the best structure for the project, in terms of both working with it in VS (the data source view is already horribly messy, but I don't think it can be split up?) and also avoiding processing the conformed dimensions multiple times.  If not, what is the best approach to follow to avoid duplication?  Using linked dimensions sounded like the right approach, until I read about how they were then co



I have a table in my database and I need to create a BATCH Process to populate the table daily at a  given time.

The table should be emptied and repopulated each time the BATCH Process runs. I am pulling the data into the table from a VIEW?????? ANY HElp





I have a table in my database and I need to create a BATCH Process to populate the table daily at a  given time.

The table should be emptied and repopulated each time the BATCH Process runs. I am pulling the data into the table from a VIEW?????? ANY HElp


Excel 2007/2010 - SSAS 2008 R2 Offline cubes


Hi all. I have a question regarding offline cubes (offline data files) in Excel 2007/2010 connecting to SSAS 2008 R2. When I try to make an offline data file in Excel I get a OLE DB error. The server I am trying to connect to is at a hosting partner on a different (but trusted) domain but I have admin rights on it. I then took a copy of the SSAS database and moved it to my own pc and could then create offline data file. I thought it might be a firewall issue on the server and tried turning it off, but the OLE DB error came again. I therefore think that there is something that happens over the network and is blocked by the hosting partner. I probably should tell that I am also SSAS admin, so it is not because of lack of rights on the SSAS that I get the error.

What I like to know if there is anyone who knows this problem or knows what happens when you try to create offline data file against SSAS in Excel? Specifically what is transferred between the client and the server, what ports and are there any programs run or code executed to create the offline cube on the client that might be blocked by typical network/domain settings/rules?

SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider



I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

Workflow Approval Process not setting item's Approval Status



I've been pounding my head against the desk about this all afternoon.  I have a simple workflow attached to a document library that runs on item creation.  All it does is start the approval process on the current item and emails me and a few other people a task (in parallel).  I have another workflow attached to the document library that runs on modify and it looks to see what the Approval Status of the Current Item is.  If the Approval Status is Approved, the workflow copies the item to another library then deletes the current item.  Same with rejected (only sends it to another library).  Pending does nothing.  I modified the Completed step in the approval workflow to modify the item (to make sure the second workflow triggers)

All that works except, no matter what the Approval Status is alway Approved!  Even when first create the item and run the approval process, the item comes out as approved.  I even explicately set the Approval Status to Pending at the beginning of the first WF, but right after that, the item reverts back to being Approved.  How do I make the item be Pending until everyone has responded to the approval task?  I kinda thought that was the default procedure...


Calling remote batch file using Execute Process Task



The requiement is to create excel file. I cannot run this code using SSIS vbscript task because this requires Microsoft.Office.Interop DLL which can not be installed on the dev / prod server. Hence using the SQL task the data exported to excel.

But now the excel is required to be updated to merge some cells. The approach we are thinking is to keep VBS file with required code to UNC path. Keep the BAT file running VBS file using CSCRIPT command in same location. Call the BAT file from SSIS package using Execute Process Task. This approach is tested in local system and also works on dev server. But somehow the sample code used to create excel is not creating excel to UNC path.

VBS code below

Const xlSaveChanges = 1
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.Cells(1, 1).Value ="Test value"

The BAT used to call above VBS file is given below

cscript \\server.com\folder$\Demo\Excelfile.vbs

The above UNC path is used in execute process task package which runs fine. But the file is not yet created.


SSAS cubes failed in SSIS



 Master Package containing
    a) A sequence of SSIS packages
    c) Precedence constraint to
    b) Analysis Services Processing Task to process our cubes
2. SQL Agent Job which runs the Master Package

Taking the cube processing in SSIS package and putting SSAS commands into the job
This seems to work, but we don't know why it is not working.

In BI SSAS cubes are working fine.

But SSAS cubes in SSIS package showing the following error

"Internal error: The operation terminated unsuccessfully. "

Pls help me to solve


What type of account is needed for deploying/maintaining SSAS cubes in SSAS 2008 R2


Hi All,

Can someone help in understanding what type of account is needed for deploying/maintaining SSAS cubes in SSAS 2008 R2?

Does one have to be in the local administrators group on the SSAS server? Can a domain group/user (non administrator) be assigned to any role that enables them to deploy cubes etc. If so, what Impersonation Mode will be used from within the dev studio while trying to depoly the project?

Can someone point to any documentation as well. I must not be searching right as I am not able to find an exact information.



SSIS job to check if SSAS cubes are working


Hi all,

I am having some management problems and need to prove that the cubes are available for browsing.

I have had a look at SSIS to see if there is a task but I suspect I need to script something out.

Can anyone give me any pointers ?

Many thanks.

SSAS Standalone just to build cubes?


My company is not currently running SQL Server (much to my dismay). Prior to a few months ago, I was using MS-Query through Excel to build cubes for large datasets for OLAP (with Excel) analysis. Although clunky, this was still working for me. Then they upgraded everyone to Excel 2007 and the new version of MS-Query no longer provides the ability to build OLAP cubes (again to my dismay).


I was wondering if there was a standalone download of SSAS or other (FREE) MS tool that would allow me to build OLAP cubes for analysis with Excel? A google search of "download SSAS" was not helpful. Can anyone point me in the right direction?


SSAS Cubes from Teradata



  I am trying to add a fact table and two dimension tables from Teradata.But when i create a Data Source View,it does not allow me to pull all the three tables.I tried  both the .NET and Ole Db Provider for Teradata.But no luck.Can someone help me please


Passing Argument from Execute Process Task (SSIS) to a Batch File



I have a batch process set up, which executes fine as long as the name of the file is built in.  My Execute Process task in SSIS also runs this batch file with succes.

I would like to pass the name of the file as a parameter from the Task (SSIS) to this batch file.  Looks like I am doing something wrong because it is failing.

This is the batch file:
cd \Program Files\WS_FTP Pro\
wsftppro -s "local:D:\Folder1\Folder2\%1" -d HDMS:/To_HDMS/

---  The %1 is the parameter

The argument that I am passing in is in the 'StandardInputVariable'

Would really really appreciate some help!  Thanks so much!

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend