Tim Crocker 2 Posted April 21, 2021 Share Posted April 21, 2021 I am trying to create a configuration block to filter an Microsft SQL Server Analysis Services cube via an Automation Services job.. I have the cube connected as external. My Automation Services job will run without errors, but no data is being displayed. When I reset my filters manually I see all the data, so a filter seems to have been set. To check if my values, column name, etc. were correct I created a test analysis, and loaded the column in question into memory vs external. Because the table and column names were identical I was able to test my Automation Services job unchaged and it worked perfectly against the loaded data, so my syntax of table, column name and targetted values were all correct. What needs to be done different to set up configuration block filtering in an cube FYI - I have created the filters in question. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now