dbTalk Databases Forums  

Caculated Cell in Sample App is different from AS Browse Data

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Caculated Cell in Sample App is different from AS Browse Data in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vinicius Bellino
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.