Re: Cube does not show data when specifying aggregations
- From: "Vidas Matelis" <Vidas.Matelis@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 2 Apr 2007 17:42:39 -0400
Hi Gborda,
I read about cases when after adding aggregates sometimes data is showed
incorrectly. But then it was reported that reprocessing of cube would fix
this.
Now your case is different. You somehow can reproduce problem. So I am not
sure what to suggest. Probably best thing would be to contact Microsoft
support and open case.
Actually If you have time, you can do few more tests, but if they do not
help, Microsoft Support should:
1. IN the cube designers Calculation tab comment out everything except
"Calculate" statement. Maybe by any chance you have calcuations that
interfere with your results.
2. Review your slicers, queries for partitions.
3. IN your browser make sure you enables "Show empty cells".
Not likely this will help, but....
Sorry could not help you,
Vidas Matelis
http://www.ssas-info.com/content/blogsection/8/63/
"gborda" <gborda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E574C15-A7CE-44DD-A10D-9146DB40C483@xxxxxxxxxxxxxxxx
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.
.
- References:
- Prev by Date: Re: Trouble using real-time ROLAP with proactive caching
- Next by Date: Re: Any alternative to crossjoin to get related attributes on rows
- Previous by thread: Re: Cube does not show data when specifying aggregations
- Next by thread: Re: Cube does not show data when specifying aggregations
- Index(es):
Relevant Pages
|
