Re: Cube Processes - No Measures!

Tech-Archive recommends: Speed Up your PC by fixing your registry

Check that you calculation script has

CALCULATE;

as the first line. If it is missing you get the behaviour you describe.
If the calculate statement is missing the measures are not aggregated
and you will only see figures if you drill down to a leaf member on all
the dimensions.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <518A5AD1-3F3C-4B90-B1EF-D683C00EB8B7@xxxxxxxxxxxxx>,
paulbihs@xxxxxxxxxxxxxxxxxxxxxxxxx says...
Anyone have experience with processing a cube, the dimensions are all
browseable, but the measures are empty?

What are the typical causes?

tia,

paul


.

Relevant Pages

  • Re: Question about initializing variables.
    ... There's also Missing, as well as Null, Empty, and Nothing. ... Dim var1 As Variant ... The value that is equal to both zero and a zero-length string is called Empty. ...
    (microsoft.public.access.formscoding)
  • Re: Question about initializing variables.
    ... Dim var1 As Variant ... The value that is equal to both zero and a zero-length string is called Empty. ... Since we passed in only 2 arguments the 3rd one is Missing. ...
    (microsoft.public.access.formscoding)
  • Re: Spelling Grammar Dialog Box Explain button missing
    ... Is it always missing? ... Blog: http://word2007bible.herbtyson.com ... >> It shows up only when the flagged word contains a grammar problem (or, ... >> Is the flagged problem for grammar (should have a green underline and>> the ...
    (microsoft.public.word.spelling.grammar)
  • Re: Need help in formulating a HREF link
    ... you're missing a double-quote. ... >> Curt Christianson ... >> Blog: http://blog.Darkfalz.com ... I checked the correct value of grantid via ...
    (microsoft.public.inetserver.asp.general)
  • Re: Autonumber Problem
    ... empty the fields and set string in some field. ... > future that people are going to be asking question about the missing gaps. ... not as long as you are using a Autonumber field in the tables. ... >> Dim rec As DAO.Recordset ...
    (microsoft.public.access.formscoding)