SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSAS browser missing Data


SSAS browser missing Data

Author
Message
ldorian81
ldorian81
SSC-Addicted
SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)

Group: General Forum Members
Points: 444 Visits: 323
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.
Sam Vanga
Sam Vanga
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 502
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
ldorian81
ldorian81
SSC-Addicted
SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)

Group: General Forum Members
Points: 444 Visits: 323
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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28235 Visits: 13268
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.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
ldorian81
ldorian81
SSC-Addicted
SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)

Group: General Forum Members
Points: 444 Visits: 323
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.
Sam Vanga
Sam Vanga
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 502
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
ldorian81
ldorian81
SSC-Addicted
SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)

Group: General Forum Members
Points: 444 Visits: 323
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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28235 Visits: 13268
SSAS should always display all data, regardless of edition.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
ldorian81
ldorian81
SSC-Addicted
SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)SSC-Addicted (444 reputation)

Group: General Forum Members
Points: 444 Visits: 323
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search