Caculated Cell in Sample App is different from AS Browse Data -
12-03-2004
, 01:10 PM
Hi,
I'm doing a query that returns one calculated cell value. But when I
query AS through Sample Application I get a different value from the
one I get when I browse data in Analysis Manager. Considering the
following points, what can be happing?
1) I'm sure I'm in the same database, cube and cell;
2) The cell is in the leaf member of all dimensions;
3) I cleaned all kind of cache, like restarting AS, SQL Server and IIS
(my app creates an AS Cache in IIS);
5) I have no data for this cell either in fact table and writeback
table;
6) There's just one formula, a calculated cell, working in this cell;
8) This strange behaviour seems to be started recently and it's
happening with other calculated cells as well;
8) I'm using the native features directly, I mean, AS Browse Data and
Sample App.;
9) I haven't had any environment trouble on my machine;
10) This is the query I've used in sample app:
select
{[Período].&[25]} on columns,
{[Versão].&[-18]} on rows
from RC
WHERE ([Indicador].&[1],[Canal].&[-10],[Centro de
Custo].&[-4],[Empresa].&[-4],[Projeto].&[-4],[Produto].&[64],[Measures].[Amount])
10)
How is it possible?? What else could I try?
Thanks in advance,
Vinicius Bellino |