Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cube not visible in Excel, PerformancePoint after SSIS processing Expand / Collapse
Author
Message
Posted Friday, January 17, 2014 8:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 312, Visits: 502
Good morning-

I have an SSIS package that calls an Analysis Services DDL task to do a full process of our cube as part of our batch ETL. The cube is processing successfully, but in the mornings it is not visible in the SSAS database through Excel or PerformancePoint. The "Visible" property in the measure group is set to True so I don't believe that is the issue. We can see the cube (and browse it) in SSMS after it processes.

I'm new to Analysis Services in SSIS and I'm wondering if I am missing a step after processing; is there something else I need to have the package do to deploy the cube?

Thanks in advance,

Jason
Post #1532102
Posted Friday, January 17, 2014 2:21 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:23 AM
Points: 1,135, Visits: 1,149
Jason Marshall (1/17/2014)
Good morning-

I have an SSIS package that calls an Analysis Services DDL task to do a full process of our cube as part of our batch ETL. The cube is processing successfully, but in the mornings it is not visible in the SSAS database through Excel or PerformancePoint. The "Visible" property in the measure group is set to True so I don't believe that is the issue. We can see the cube (and browse it) in SSMS after it processes.

I'm new to Analysis Services in SSIS and I'm wondering if I am missing a step after processing; is there something else I need to have the package do to deploy the cube?

Are you using the same account/login when you view/browse the cube successfully in SSMS as when you are unsuccessfully connecting via MS Excel?

What happens if you manually process your cube? Are you getting the same issue?

HTH,
Rob
Post #1532284
Posted Friday, January 17, 2014 2:22 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 312, Visits: 502
If I manually process it, it becomes visible.
Post #1532285
Posted Friday, January 17, 2014 2:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:23 AM
Points: 1,135, Visits: 1,149
I just took a look at one of my SSIS packages that contains the Analysis Services Processing Task. I just have my processing settings to 'Process Full'; there's not anything else I'm aware of that you would need to set for that task.

Rob
Post #1532290
Posted Friday, January 17, 2014 2:40 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
When you say "at the end of your ETL", do you mean:

1. Load DBMS dimensions and facts, THEN Fully Process Dimensions and Facts?

2. Process 1 SSAS object at the end of each SSIS package i.e.(Load dimension 1>>Process Dimension 1, Load Dimension 2>>Process Dimension 2, Load Fact Table>>Process Measure Group Fully.

3. Some other ETL pattern
Post #1532294
Posted Friday, January 17, 2014 2:49 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
Right now the only thing I can think of is that

1. The user browsing by Excel does not yet have cube access (as already stated).
2. The Measure Group is not in a processed state. Excel requires dimensions and measure group(s) to be in a processed state.
3. Proper OLE DB provider not installed in the machine that is using Excel.
Post #1532297
Posted Saturday, January 18, 2014 9:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 312, Visits: 502
sneumersky (1/17/2014)
When you say "at the end of your ETL", do you mean:

1. Load DBMS dimensions and facts, THEN Fully Process Dimensions and Facts?

2. Process 1 SSAS object at the end of each SSIS package i.e.(Load dimension 1>>Process Dimension 1, Load Dimension 2>>Process Dimension 2, Load Fact Table>>Process Measure Group Fully.

3. Some other ETL pattern


Number 1. We process full after the DBMS incremental loads as we're in a pretty fluid state right now.

I replaced the DDL Task with the Processing Task yesterday and redeployed the ETL package; this morning I could see the cube in Excel. Still waiting to hear back from the team to see if anyone manually processed it.
Post #1532385
Posted Monday, January 20, 2014 8:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
The only other thing I can think of is the driver on the machine running Excel; however, if I am reading this correctly, you are able to see the cube using Excel after you manually process the cube. Therefore, that leads me to believe it is NOT a driver issue.
Post #1532664
Posted Monday, February 03, 2014 11:54 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
I've also seen folks accidentally deleting the default "CALCULATE" command, which is the first command, in the calculations tab--which has resulted in the cube being processed, but nothing being visible come browse time!

The CALCULATE command controls the aggregation of leaf cells in the cube. If the CALCULATE command is deleted or modified, the data within the cube is affected. You should edit this command only if you manually specify how the cube is aggregated.

Post #1537452
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse