I have the following MDX Script gives me a wrong Grand Total Values.
AS ([Measures].[DC] , [RowType].[Row Type Key].&),
View Complete Post
View Complete Post
Hi. I'm working on a conditional piece of mdx that started looking like what you see way below. The idea is to modify this measure's behavior based on which dimension was chosen without nesting scope statements. The detail and date hierarchy
level numbers look good on Date A but the grand total is 0 when I dice on Date A. I suspect what was posted at
explains why this happens but the solution given there applies to a different class of problem (I think).
Can someone help to explain how grand totals etc can be aggregated properly for calc'd measures? I tried multiplying [Whatever Orig] by 1 and even put the calc'd member in a different measure group to no avail. I also used a raw assignment prior to
the calculate that kind of looked like [measures].[Whatever Orig] = IIF(ROOT([Date A]),0,...) ; but that didnt work either. Eventually there will be more scope statements.
After going through all available posts, unfortunately I could not find a solution for my problem. I have to create a dynamic named set of with TopCount in a cube that will be accessed with excel 2007. This how the outcome should look like:
Grand Total $300.00
This is the MDX I used which gives me the top 3 but not the "Others" and the "Grand Total." Just to keep it simple I used top 3 Brands.
CREATE DYNAMIC SET CURRENTCUBE.[Top 3 Brands]
, DISPLAY_FOLDER = 'Sets';
Now I am stuck here. After reviewing many posts it seems that Excel 2007 has some issues with handling sets. I found two possible solutions from Raymond-Lee which I think may work.
Solution 1 - Use a named query in dsv
Solution 2 - create a dummy "Others"
Here is the post:
Is it possible to disable the sub/grand total column in calculated memebers programmatically. I don't want to display the sub/grand totals in pivot table? I know I can manually disable the sub/ grand totals in pivot table.
I have a cube where I added a calculated member to extract the last non null value of a measure. This is the script
Create Member CurrentCube.[Measures].[Trascinamento] as
FORMAT_STRING = "Currency", VISIBLE = 1 ,
ASSOCIATED_MEASURE_GROUP = 'PUMA';
when viewing the aggregate data in a hierarchy, calculated totals and subtotals are accurate only if all the children of a member are zero at a certain date, and if either
has a value, the original total is not zero, and thus is also used in calculated member.
hierarchy | importo | trascinamento
100-----10| null | 10000
----20 | null &nb
I have an end user request to display “Grand Total” at the left of a Pivot Table. The client uses Excel 2007 and SSAS 2005
For instance, take a look the grand total at the left of the table
I have one report in which i have to show list of patients, department wise.. so i added one group for Department and patient belonging to respected department fall under that group.. but the requirement is each department (group) should start from new page..
till now everything works fine.. now the point is at the end of report i have to print total no. of patients (Grand total) included in all departments.. but this Grand Total is appearing one new page even if previous page completes half of the page, as
i have activted "New Page After" for group property.. how to overcome this problem ?
Below is my testcase. I want to display grand total without any sub total.
create table report (name varchar(6),type1 varchar(6),amt int)
insert into report values( 'ABC','BILL',200)
insert into report values( 'DEF','BILL',200)
insert into report values( 'ABC','Query',100)
insert into report values( 'DEF','Query',100)
insert into report values(
I use the sum descendant function to sum the employees that has a sale using the following MDX
Employee with sale =
,[Measures].[Employee wSales Count1]
The result is like this if I have all job category selected.
Employee with sale
I run a simple .aspx website on a Windows Server 2008 machine.
There is NO impersonation, and
System.Security.Principal.WindowsIdentity.GetCurrent().Name returns NT
AUTHORITY\NETWORK SERVICE, which it the account which the application
pool runs. In my web.config, I have <authentication mode="Forms">.
I tried to test the security of the
application and server by removing file permissions to the .aspx files. I
was greatly worried when the website continued to run without problem
(it should not have been able to read the .aspx files).
on file level auditing, I discovered that the .aspx files were being
read by the machine$ account (if the machine is called Serv1, then the
files would be read by the Serv1$ account, which seems to have access to
all files on the local machine).
Is this a security breach or is this behaviour by design ?
Please can somebody assist, as I am worried.
Im trying to updated some old ASP pages with some new .net pages and cant seem to get this update statement to work. I need to update the current ASP code below and then once thats working im going to use that same statement in a procedure for all our new .Net pages..
So can anyone see what im doing wrong by inserting the 2nd column to the update statement?
strSqual = "update tas set date_completed='" & TransDate & ", trans_id=" & InsertedTransID & "' where date_completed is null and sercontract_id="& strContractID & " and DATEDIFF(dd,task_due_date,'" & strProcDate & "')<=14"
I am trying to add an extra column to the update, but not sure if the syntax is correct. Usability in Practice: When Things Go Wrong This month our usability experts explain what it takes to create informative, useful error messages.Dr. Charles Kreitzberg and Ambrose LittleMSDN Magazine January 2009
This month our usability experts explain what it takes to create informative, useful error messages.
Dr. Charles Kreitzberg and Ambrose Little
MSDN Magazine January 2009
UDP, the lesser-known sibling of TCP, is used for DNS resolution, SNMP network status, Kerberos security, digital media streaming, VoIP, and lots more. Learn how to put UDP to work for you.
MSDN Magazine February 2006