dbTalk Databases Forums  

Problems with MS Query

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


Discuss Problems with MS Query in the microsoft.public.sqlserver.olap forum.



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

Default Problems with MS Query - 12-29-2004 , 02:21 AM






Hi There

I have big problem with MS Query. I'm using
MS SQL MSDE (sometimes Access files) engine as warehouse. I created
ODBC data source. To create OLAP cubes I'm using MS Query.
It's nice tool for my needs. I have four aggregating functions:
- Min
- Max
- Count
- Sum
It's working without Sum. When I try to use Sum function
I receive:
"There is no possibility to write this module. Change definition
of this module and try again. If you are updating existed modules file
ensure that file is not used by Excel or other applications."
Does anobody help me in that issue?

Regards
sajdor



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.