Re: Calculate

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

hello,

in the AdventureWorks everything is working fine, the assignment used for [95]
writes in the empty cell.

In my project there is a report where we need to always display a specific
category ([Policy Revenues]) and all accounts assigned to this category. By
always, I mean when user selects a combination Year and Quarter(s) where
there is no data in the fact table (no transaction where one account is
involved).
Because the main query uses the Non Empty operator all empty cells (leaf
cells and non-leaf cells) are removed; my design is to replace some empty
cells (a subcube) with 0.

In the default MDX script (after the Calculate statement) what is allowed and
also persisted in terms of assignments/scoped calculations?
The assignment for a leaf-cell (valid record in fact table) is it persisted
(of course no other assignment will not re-write it)?
What about the non-leaf cells (aggregated cell)? Are they persisted?
So far in my tests the answer is No.

I did not find any documentation or best practices docs for this problem and
I really appreciate your help. In one book I found ' avoid make assignments
to leaf cells because the entire cube will be re-process'.

Thank you for your time
DG

dpuri wrote:
Could you explain, at a high level, why you think null cells need to be
set to 0 in your scenario, since that's still not clear.

As for 0's reverting to null, could you describe how to reproduce this
issue in Adventure Works - that would help in debugging/confirming, and
in identifying the cause?

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-olap/200903/1

.

Relevant Pages

  • Re: Game
    ... In this event handler you update your game state ... Not all browsers creates a global variable pointing to the element ... assignment only need to run in IE, ... two unpicked cells until you succede (average number of tries is only ...
    (comp.lang.javascript)
  • Re: Help with Homework
    ... There were 14 students that did not do this assignment. ... You must print a sentence with the I.D. numbers of the students who did not take the test. ... Any empty cells that are found must be counted and the number of them declared in the output statement. ... Where Scores is the variable name that stores the matrix from the Excel file. ...
    (comp.soft-sys.matlab)
  • RE: open / close files and display names
    ... Change the cells .Value assignment to ... and change those single quotes to double quotes (remember you're in ... That should fix the immediate problem. ...
    (microsoft.public.excel.programming)
  • Re: VLOOKUP #N/A Sometimes but not always
    ... Probably not all C cells are numbers, although they may look like numbers. ... Format a blank cell as Number. ... In the assignment, we're looking up a discount rate based on the ... > customer's credit score. ...
    (microsoft.public.excel.misc)
  • Re: No solution - Macros
    ... ) Then simbol = "WS" ... not finding "" cells, then replace with: ... you use to repeatedly populate your text string. ... If you want cells containing "" to represent an Empty cell then you should ...
    (microsoft.public.excel.programming)