January 22, 2013 at 10:41 am
Hi all,
I have a new SSAS Cube that I have designed and I am finding that the data doesn't seem to be pulling through into the browser within SSAS. Is this normal for the internal browser to only show a cut of the data?
When I build a new aggregation count it does recognise the correct number of rows but in the browser the same aggregation is missing a chunk.
Thanks in advance
ld
Regards
ld
Stoke-on-Trent
United Kingdom
If at first you don't succeed, go to the pub and drink away your current thought plan.
January 22, 2013 at 8:34 pm
It's not normal. Browser in BIDS doesn't hold back any data. Having said that, it is known to be buggy, at least to me. It could freeze with high data volume as well. What version/sp are you using?
I normally don't trust browser, I use Excel for browsing.
Sam Vanga
http://SamuelVanga.com
January 23, 2013 at 2:07 am
Hi,
Thanks for the reply, i'm on 2008 sp3
I have tried the connection through excel and it still shows the same amount of records as in the browser which is wierd.
I know there are 318000 records but it's only showing 240000.
thanks
ld
Regards
ld
Stoke-on-Trent
United Kingdom
If at first you don't succeed, go to the pub and drink away your current thought plan.
January 23, 2013 at 6:19 am
Make sure there are no filters in the data source view and that the dimension usage mapping is done correctly. Also make sure there are no slicers/filters in the browser.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2013 at 2:38 am
Thanks for the responses.
There are no filters on, i'm just pulling the measure into the browers and the total doesn't match the table.
I have re-processed the cube and it still does not show the correct amount.
I rebuilt the cube from scratch and the totals were correct on the day it was build however now even tho the data has been updated in the tables it does not show the recent data.
Is there something i'm missing? i.e. a cube update scehdule or something? I never had to do this on any of the other cubes i've built but that was a couple of years ago and in a previous job.
Re-processing the cube doesn't pull the new data in.
Regards
ld
Stoke-on-Trent
United Kingdom
If at first you don't succeed, go to the pub and drink away your current thought plan.
January 31, 2013 at 6:40 pm
This is strange!
Try this: (just some steps to debug, not gauranteed to work)
Capture the query using SQL profiler that is executed in the data source view to pull fact table. Run it in SSMS and manually verify to make sure the results are expected.
Do process clear. This will remove all data from SSAS objects. Then do a process full. May be that helps.
Sam Vanga
http://SamuelVanga.com
February 1, 2013 at 2:42 am
Hi Sam,
Thanks for the reponse.
I don't have permisions to run SQL Profiler, this has been deemed a DBA function... :unsure:
Could it be to do with the server being Standard Edition?... I'm used to Enterprise (only been at this company for 3 months)
Also I'm on 2008 std not R2
I'm using SSIS to process the cube, the settings choices it shows are..
Process Default
Process Full
Process Data
Process Structure
UnProcess
Process Incremental
Process Index
I have tried UnProcess and then Process Full but it has had no effect.
Regards
ld
Stoke-on-Trent
United Kingdom
If at first you don't succeed, go to the pub and drink away your current thought plan.
February 1, 2013 at 2:49 am
SSAS should always display all data, regardless of edition.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 1, 2013 at 3:20 am
Then i'm baffled,
I've rebuilt the entire Cube and tables from scratch and the data is spot on at that point, but then won't update the data on the next increment.
Regards
ld
Regards
ld
Stoke-on-Trent
United Kingdom
If at first you don't succeed, go to the pub and drink away your current thought plan.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply