SSAS browser missing Data

  • 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.

  • 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.

  • 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.

  • 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

  • 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.

  • 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.

  • 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.

  • 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

  • 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