Re: Cube does not show data when specifying aggregations

Hello:

I tried defining the percentage (70%) for 12 partitions at a time, cube has
60 partitions.

When I tried for the first 12 partitions, cube had data.

When I tried for the second 12 partitions, cube did not show any data,
however, I could see records were read for the partitions being processed.

When I removed percentage from second 12 partitions and processed the cube,
data showed up in the cube.

Hope this helps or let me know what other information could help.


"Vidas Matelis" wrote:

Could you try process one partition at the time using MS SQL Server
Management studio and see if analysis services is reporting back how many
records are read for that partition.
Do full processing of partition, check go to BIDS, in Browser tab refresh
connection and see if there is no data. If still empty, try to gives us more
info to work on. Is removing aggregates returns data back?

Vidas Matelis
http://www.ssas-info.com


"gborda" <gborda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD7EA6E7-9495-4464-8223-E05874A262F7@xxxxxxxxxxxxxxxx
Hello:

What I am doing is designing the aggregations for each partition, so I
follow the "Aggregation Design " wizard in BIDS where I can specify a
percentage for each partition. The wizard finishes OK and I can see "MOLAP
70%" for the column "Aggregations" in "Partitions" when I edit the cube,
but
the problem happens after I process the cube, and I do not see any data.

"Jesse O." wrote:

have you added any custom aggregations?


"gborda" <gborda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BCBA1959-0181-4194-B91D-7B2AB4D9F629@xxxxxxxxxxxxxxxx
Hello:

I have a SSAS 2005 cube I migrated from AS 2000. Migration went fine,
and
after migration, cube partitions had 0% aggregations. I changed
percentage
to
70% and fully processed the cube, but after processing finished, cube
does
not show any data. When aggregations were 0%, cube had data.

I am browsing the cube using BIDS ("Browse" option) and/or Crystal 10,
and
I
get no data in both.

Has anyone experienced this behaviour ? If so, how can I fix this ?

Thanks.





.

Relevant Pages

  • Re: SSAS2005 - When do partitions need to be processed?
    ... My guess here is that it is not aggregations but rather indexes being ... The actual processing of partitions doesn't appear to be significant here ... Processing Cube 'Sales Current' completed successfully. ... aggregations when the dimension is updated. ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube does not show data when specifying aggregations
    ... I tried defining the percentage for 12 partitions at a time, ... When I tried for the first 12 partitions, cube had data. ... What I am doing is designing the aggregations for each partition, ... after migration, ...
    (microsoft.public.sqlserver.olap)
  • Re: Multiple Cubes Sharing mdx Calculations?
    ... "I still see only 1 Fact table in the Cube browser. ... Different Fact Tables for Partitions ... view, from different data source views, or from different data sources. ... Cube partitions each have a slice for each attribute. ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube does not show data when specifying aggregations
    ... IN the cube designers Calculation tab comment out everything except ... Review your slicers, queries for partitions. ... What I am doing is designing the aggregations for each partition, ... how can I fix this? ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS 2005 perform worse performance that 2000
    ... The slicer parameter is recommended but optionnal for your partitions ... recomend change memory settings. ... Our cube files takes about 35 GB, but database Estimated Size from cube ... queries from cache filtered 500000, Total queries from cache direct 30000. ...
    (microsoft.public.sqlserver.olap)