Home > Forum Home > Analyzing Corporate Financial Data > A requirement in Excel 2007 with SSAS cube Share

A requirement in Excel 2007 with SSAS cube

Excel Help for A Requirement In Excel 2007 With Ssas Cube in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

A Requirement In Excel 2007 With Ssas Cube

Rate this:
(3/5 from 1 vote)
ConfusedI am using a ssas CUBE as the datasource for creating reports in Excel 2007. There are 3 tabs in a sheet each having separate connection from the same cube. There should be only one set of prompts for all the 3 tabs. If a user selects values in the promts/parameters in the first tab,it should get applied for all the tabs.

Is it possible?..
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
OopsYou could change the required pivot table field selections in multiple sheets from the values in the first sheet using some VBA code.
Assuming that the values chosen are in cell ranges in the first sheet, it would be a good idea to first name the ranges with the chosen values so that they can referenced easily.  If the values are within forms such as list boxes, you can use the MATCH and INDEX functions to return the selected value in a cell.
The VBA code then looks something as follows.
VBA Code:
Dim cellval1 As Variant
cellval1 = Range("namedrange1").Value
Sheets("sheetname1").PivotTables("pivottablename").PivotFields("pivotfieldname") = cellval1
It may be a good idea to first record a macro to change the pivot tables in order to get the correct code for to chnage the selection in each pivot table.

 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for A requirement in Excel 2007 with SSAS cube in the