January 17, 2014 at 8:51 am
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
January 17, 2014 at 2:21 pm
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
January 17, 2014 at 2:22 pm
If I manually process it, it becomes visible.
January 17, 2014 at 2:29 pm
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
January 17, 2014 at 2:40 pm
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
January 17, 2014 at 2:49 pm
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.
January 18, 2014 at 9:42 am
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.
January 20, 2014 at 8:05 am
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.
February 3, 2014 at 11:54 am
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.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply