Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS browser missing Data Expand / Collapse
Author
Message
Posted Tuesday, January 22, 2013 10:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:43 AM
Points: 279, Visits: 232
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.
Post #1410159
Posted Tuesday, January 22, 2013 8:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 43, Visits: 324
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.

http://svangasql.wordpress.com
Post #1410318
Posted Wednesday, January 23, 2013 2:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:43 AM
Points: 279, Visits: 232
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.
Post #1410410
Posted Wednesday, January 23, 2013 6:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 13,253, Visits: 11,032
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1410528
Posted Wednesday, January 30, 2013 2:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:43 AM
Points: 279, Visits: 232
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.
Post #1413529
Posted Thursday, January 31, 2013 6:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 43, Visits: 324
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.

http://svangasql.wordpress.com
Post #1414419
Posted Friday, February 1, 2013 2:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:43 AM
Points: 279, Visits: 232
Hi Sam,
Thanks for the reponse.

I don't have permisions to run SQL Profiler, this has been deemed a DBA function...

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.
Post #1414516
Posted Friday, February 1, 2013 2:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 13,253, Visits: 11,032
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1414519
Posted Friday, February 1, 2013 3:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:43 AM
Points: 279, Visits: 232
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.
Post #1414531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse