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

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

SSIS job to check if SSAS cubes are working

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

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.

View Complete Post

More Related Resource Links

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


How To check Database Connection working or not in SSIS?


Hi All,


Before execute the package I want check db connection properly working or not. If don’t have proper connections I want display custom message. How to implement this task in ssis





Disable check box in a gridview does not working



I have a check box in a template field in a gridview.

Based on some condition, I want those check boxs to  be enable and disable.

I am trying the below code but does working..

 protected void GVstudents_RowDataBound(object sender, GridViewRowEventArgs e)
              if (e.Row.RowType == DataControlRowType.DataRow)
                    string studentID = GVstudents.DataKeys[0].Value.ToString();
                    int stdID = Convert.ToInt32(studentID);
                    int schID = profile.getSchoolIDByStudentID(stdID);
                    int tchrID = profile.getTeacherIDByStudentID(stdID);

                    if (patti.chkIsTeacherPaid(stdID, schID, tchrID))
                        CheckBox cb = (CheckBox)e.Row.FindControl("chkTeacherPayment");
                        cb.Enabled = false;
                        cb.Checked = true;


any help??

Gridview check all not working in Mozila Firefox


hi all,

i has an gridview first column header is Checkbox, when i click on that all the detail column checkboxes were selected if i use IE but the same not working in Mozila Firefox

below is my code

function checkAll()
                  var totalChkBoxes = parseInt('<%= gv5.Rows.Count %>');
                  var gvControl = document.getElementById('<%= gv5.ClientID %>');
                  var gvChkBoxControl = "cbCheckProd";
                  var mainChkBox = document.getElementById("chkBoxAll");
                  var inputTypes = gvControl.getElementsByTagName("input");
                  for (var i = 0; i < inputTypes.length; i++)

Determining the status os the Batch job that process SSAS Cubes

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

Check In / Check Out not working properly

At various points during the day, I check back in the master and CSS files I've been working on.  However, it doesn't show them as checked in ... they are still flagged with green check in SP Designer.   And what is more confusing, sometimes I can't save anything because it says that it is checked out.  But I'm the one who checked it out.  And it thinks it is checked in.  So I try to check it out again, and it won't let me check it out. The only way I got around this yesterday was to rename the master file.  Then rename it back to it's original name. Suggestions?

SSIS Package working on SQL Client Machine but when trying to run on SQL Server machine giving error

Hi We are trying to run SSIS package on sql server machine but sometimes it is giving error for data flow task containing Script Component. Error is - [SSIS.Pipeline] Error: component "SCR DimensionRelation" (1) failed the post-execute phase and returned error code 0x80004002. This error is not coming continuously. And also not for specific DFT. It comes for different DFTs as we rerun the package. Can anybody help me on this? We are using SQL server 2008. We are not getting any error on client machine :(:(

SSAS URL Action not working

Hi, I have a simple URL action in SSAS defined as below.  "http://website/Default.aspx?contentpage=attach.aspx?doc=" + [Customer].[Customer].CurrentMember.Name + "&cc=" + [Company].[Company].CurrentMember.Name + "&yr=" + [Time].[Fiscal Year Number].CurrentMember.Name When I right click on customer field and click on the Action, it opens up IT with "http://website/Default.aspx?contentpage=attach.aspx?doc=Customer1&cc=ALL&yr=ALL So instead of passing the correct company name, All member is passed. How do i fix this issue? Thanks, Sambath

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

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!

Member_Caption property not working in SSAS 2000

Hi, I need to pass a parameter to my SSRS report which is based on an Analysis services cube (AS 2000). I have created a query which will return me the members of a hierarchy that I can pas as a perameter. Interestingly the Member_Caption property is not working. In MDX Sample application it is returing "#err" in the column and when I run the same command in my SSRS MDX editor ( I am using OLEDB connection alongwith analysis services 9.0 client) I get empty space. My query is, WITH     Member [Measures].[ParameterCaption] as '[PRODUCT].CurrentMember.Member_caption' MEMBER   [Measures].[ParameterValue] AS '[PRODUCT].CurrentMember.UniqueName' MEMBER   [Measures].[ParameterLevel] AS '[PRODUCT].CURRENTMEMBER.LEVEL.ORDINAL' SELECT   {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , { Descendants([PRODUCT].Currentmember,1,leaves)+(Descendants([PRODUCT].Currentmember,2,leaves))} ON ROWS from   [My_Cube] Am I making any obvious mistake here ? I have used similar queries before and they have always worked (With SSAS 2005) Thanks in advance, Suman  

SSIS Debug Host has stopped working

The error code that's output with the SSIS Debug Host has stopped working popup is: Problem signature:   Problem Event Name:    APPCRASH   Application Name:    DtsDebugHost.exe   Application Version:    2007.100.1600.22   Application Timestamp:    48753d31   Fault Module Name:    StackHash_23cc   Fault Module Version:    6.1.7600.16559   Fault Module Timestamp:    4ba9b21e   Exception Code:    c0000374   Exception Offset:    000c2913   OS Version:    6.1.7600.   Locale ID:    1033   Additional Information 1:    23cc   Additional Information 2:    23cc9330c2de3c407e38eb60a3c201e4   Additional Information 3:    10bd   Additional Information 4:    10bdb3132e81c1ecfd041615b784b3fd In the output for the BIDS debugger: SSIS package "Package.dtsx" starting. Information: 0x4004300A at Sg Clients to NewCP stgClients, SSIS.Pipeline: Validation phase is beginning. Warning: 0x80049304 at Sg Clients to NewCP stgClients, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To

Calling Oracle procedure from SSIS 'Execute SQl task' is not working


Hi ,


Iam using 'Execute SQl task' which calls a stored procedure located in sql server database.The task's SQL source type is variable and the variable has the follwoing expression "EXEC PROC_SEL_MBO_REPORT "+@[User::V_SP_Job_Date]after evaluation it is like EXEC PROC_SEL_MBO_REPORT '01/NOV/2007'.It is working fine

Now the procedure is changed to Oracle.So I have changed it to "BEGIN  PROC_SEL_MBO_REPORT " + "("+ @[User::V_SP_Job_Date]+")"+"; END"+";" after evaluation it is like BEGIN  PROC_SEL_MBO_REPORT ('01/NOV/2007') END;.It is sucessfully executing from the task but no data is loaded into the tables which are used by the procedure internally.
Executing  'execute BEGIN  PROC_SEL_MBO_REPORT ('01/NOV/2007') END;' is perfectly alright from SQl developer or sql plus.

Please help me.. thanks in advance




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 Calculated Member not working as expected in a SSRS report


Dear forum guys, I have a simple cube to analyze my customer's sales. I have a Time Dimension, a Product Dimension (with a few hierarchys) and a couple measures (sales and purchase amounts).


I also have defined a few Calculated Members, in particular the average sales and purchase amount over the last 12 months from the selected month.


I need to show the results in a SSRS Report: the user must select a month and the report needs to show the sales and purchase amount of the selected month and the average of the previous 12 months (both for sales and purchases).


Everything works perfectly if I test the cube using the Cube Browser or Excel 2007 as a client.


When I define the SSRS Report I cannot get to work with the calculated members (the average): I get strange numbers which are much higher than the real numbers.


I've tried both Matrix and Table reports.


Can anyone suggest me what I'm doing wrong: I think this should be a very common mistake.


Best regards



databound checkbox default check not working


Hi I have a datagrid which is bound to a stored procedure in the code behind. This works fine. But the datagrid contains a checkbox which I need to be default checked. First I didn't bind the checkbox and just used:

<ItemTemplate>         <asp:CheckBox ID="chkSelection" Runat="server" Checked= "true" />       </ItemTemplate>

but they show as unchecked. then bound it using:

        <asp:CheckBox ID="chkSelection" Runat="server" Checked= '<%# Bind("chkSelection") %>' />

  <ItemTemplate>         <asp:CheckBox ID="chkSelection" Runat="server" Checked= '<%# Bind("chkSelection") %>' />    &nb

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