Custom Rollups on Time Dimension Don't Work After Upgrade

I've upgraded a time dimension from AS2000 to 2005. The dimension contains custom rollups for things like 'Last 14 Days' / 'Last Week' etc using:

Filter([Years].[Week].members,[Years].Properties("Current")="1").item(0).lag(1)

for the custom rollup.

These no longer work. UnaryOperatorColumn / CustomRollupColumn properties have come across without a problem. However the values displayed at each of the levels are those from the branch above (the last year stored within the dimension). Measures display N/A.

Any ideas on how to fix or to re-do using a different technique?

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:29 AM

Referenced dimension to a named calculation column

I have a cube with a referenced dimesion to a named calculation column, i suceed to define it, but when i'm doing 'Process', I get an error 'invalid column name'. what's the problem?

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:22 AM

eliminating some choises in multivalued parameters

hello to every body. well i am using sql server 2005 designer to crete reports. well it gives the opportuniry to create automatically multivalued parameters. my problem is that i want to eliminate some choises from the parameters.I noticed that sqlserver 2005 uses the member_caption function to take the values but it returns some values that i don't want.

I tried to create a new dataset with the values i want but then i have problem in taking more than one values. what can i do?

thank u in advance for your answers.

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:22 AM

get dimensions of a perspective in mdx

hi guys!

i need to get a list of all dimensions used in a perspective
so i wrote a little query that should show me the things i need:

with

member [Measures].[Rank] as '(
Rank([Date].[Calendar].currentmember, set_rows)
)'

member [Measures].[DimensionName] as '(
Dimensions([Measures].[Rank]-1).name
)'

member [Measures].[DimensionUniqueName] as '(
Dimensions([Measures].[Rank]-1).uniquename
)'

member [Measures].[Levels] as '(
Dimensions([Measures].[Rank]-1).levels.count
)'

set set_rows as '{
Head([Date].[Calendar].members, Dimensions.Count)
}'

select set_rows on rows,
{[Measures].[Rank], [Measures].[DimensionName], [Measures].[Levels], [Measures].[DimensionUniqueName]} on columns
from [Direct Sales]

BUT the query returns me all dimensions of the AdvenureWorks Cube
and not the dimensions of the perspective

seems like a bug to me :(

are there any other ways how to solve this problem?

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:23 AM

Locale and Culture

As I am developing reports to be used in severel different languages I would like to start a discussion about locales and cultures.

Hope to find answers to very simple questions like whats the difference between locale and culture and what determines the language used by the reporting service and the preview in visual studio.

Please share your expirence .

Reply:

You may want to read this: http://msdn2.microsoft.com/en-us/library/ms156493.aspx

-- Robert

------------------------------------

Something to think about. . .

Given: " x Î ( ¬null Ú VARCHAR(1)) : char(ascii(x)) = x in SQL Server 200x

Prove: '' should be considered a null in SQL Server 200x

declare @test varchar(1)
set @test = ''
Select case char(ascii(@test))
when @test then ''''' is not null'
else 'Q.E.D.' end

'Q.E.D.'

\ : '' = null, because char(ascii('')) ¹ ''

getting in touch with beta team manger for vista b2

Wolfie2k6 and Richard WU,

I have the beta tester upload tool for problems and the feedback link on dtop. really been there done that, don't work at all.

I keep getting letters from msconnect saying I'm not a beta

tester. and I'm really getting ticked off about it.

M.G.S.

Reply:

As you may not have a beta user ID, I will suggest you to post in newsgroup.

------------------------------------

Do not delete things, it bites

Hello,

I noticed that when you delete things or substitute tables, you get in trouble.

- Delete a named query used in a partition before deleting the partition

- Delete a named Calculation from a table in the Ds view, whathever you do

- Replace a table with another table which has less columns even if none of the lesser columns are used nowhere.

The XML do not get updated accordingly leading in all kinds of errors, some requiring restore from an older version.

Just a FYI.

BTY, I do not know how to submit bug reports.

Philippe

Build 9.00.2175.00

Reply:

go to connect.microsoft.com

------------------------------------
Reply:

I think we have both come across the same problem (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=640957&SiteID=1).

For permissions, I have manually cleaned up the xml files. If you post this on connect.microsoft.com, let me know as I cannot do that. I can vote for it.

btw, how did you get build 9.00.2175.00?

------------------------------------
Reply:

Yes, the changes you made in DSV will not propagate to other linked ojects. Since you are deleting things from DSV, the related binding will be broken and it is up to the user to rebind or remove it. Anyway, you should get validation error when you try to deploy and find out the broken binding.

We have already got customer request on this issue. We will consider to improve the user experience in the next release.

------------------------------------
Reply:

I disagree. It is not a case of improving the user experience. It is a bug.

------------------------------------
Reply:

A bug means that the software is not doing what it is supposed to do in the design spec. This is not a bug because we don't have it in design spec. You can say it is design flaw. However, from the user experience, people hated to see something that deleted automatically without any control. Therefore, what I suggested is to enhance the user experience. After deleting the objects in DSV, we could show a list box to list all the broken bindings and give user the option to delete the broken objects. Some advanced users may want to leave the broken bindings so that they can bind to different things instead of regenerate the objects or redo all the modifications.

Anyway, we already addressed the issue. We will consider it in future release.

Thanks

------------------------------------
Reply:

This often happens when building complex products such as SQL2005. Do not take it the wrong way.

When is the planned release of the fix?

------------------------------------

Is it possible to create a measure of data type string?

I'm attempting to build a cube that will dynamically pivot normalized data in a table.

table contains the following columns: column, client, name, columnvalue

I want to put client and name in the rows, column in columns, and columnvalue in detail fields.

columnvalue is datatype string - which would be non-aggregatable.

I am unable to create a non-aggregateable measure of type string for the columnvalue. Even though both string and non-aggregatable are options for building a measure.

Any ideas how I might work around this? Calculated Measure? Custom datatype?

--Neil

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:24 AM

Excel Add-in for Analysis Services - What-If

Hi *,

I'm having a hard time with the Excel Add-In for Analysis Services What-If function. Correct me if I'm wrong, but the what-if function is the only possibility to write-back to a analysis services cube, right?

My problem is that every time I try to run What-If Analysis I get an error message saying that non of the cells satisfy the all-dimension rule. That does'nt make any sense since I'm working with a AS2005-only cube...

Any ideas?
Thanks a lot!
Steve

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:24 AM

DVD, installation & Corp Networks

I am very disappointed that Vista only comes on and requires a DVD ROM. For one, in my experience in corp networks & equip purchases DVD ROMs were not regularly purchased with new equipment as these were seen as an unnecessary expense. So now that Vista is requiring it, corp networks are going to be hard pressed to go out and purchase one for each and every computer. Even if the argument is to go purchase an external one and use that....the read/write speed on external drives are going to slow down the upgrade process and increase IT costs. And what is going to happen if one is used and later on a file is needed from the DVD? Is the OS at that point going to work with repointing it to a network drive, and will it automatically find the correct path for whatever file it's looking for, or are IT employees going to have to spend countless hours finding proper paths for files?

I'm hard pressed to see imaging work out as a viable alternative, as every time I have seen it used even with SYSPREP there ends up being a problem with the chipset and/or additional necessities for all drivers across different hardware.

Deleting a Role does not delete <DimensionPermission> from the dimension or cube

While trying to delete a role that had cube permissions, it prompted me that it was going to delete the permission from various objects, but it did not. This is in the cube after deletion for RoleID Role 2. Then create a new role and the the RoleID given is Role 2. This is dangerous as it inherits the old role permissions.

Is this a bug?

<ID>CubePermission 3</ID>

<Name>CubePermission 3</Name>

<Read>Allowed</Read>

<ReadSourceData>Allowed</ReadSourceData>

</CubePermission>

The more dangerous one is:

<ID>DimensionPermission</ID>

<Name>DimensionPermission</Name>

<Read>Allowed</Read>

<AttributeID>DIVISION CODE</AttributeID>

<AllowedSet>{[RESTATED MARKET].[DIVISION CODE].&[020]}</AllowedSet>

</AttributePermission>

</AttributePermissions>

</DimensionPermission>

</DimensionPermissions>

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:24 AM

Application for SQL Server connect at http://connect.microsoft.com/availableconnections.aspx

Has the application for SQL Server connect at http://connect.microsoft.com/availableconnections.aspx closed? I cannot apply for SQL Server connection to submit issues. I can view them.

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:24 AM

Language Conversion

Hi all,

I'm working on Business Intelligence tool. now i'm facing some probs regards to Thai lagauage conversion

brief idea about our application: J2EE based, back-end is MySqL .

for making cubes we are using MS analysis Manager.Transactional databse: MS Sql server( i have changed the language settings, now i can show the data in Thai format in the database)

Problem: when i processing the cubes in our application, i'm getting error message eg:??? symbol

i had a chat with one Java person. he said i need to change the unicode cofiguration setting in the Java file.

I browse through the entire application but i'm not able to getting the MS language Translation code(unicode configuration code).

pls suggest:

abiantony@hotmail.com

Changed type Ed Price - MSFTMicrosoft employee Monday, May 11, 2015 5:25 AM

RC1 updated info

Hi everyone. I just wanted to share this information that was recently posted on the TechNet Vista Blog page by NWhite. Also, RC1 release looks to be getting close .

OK, so I've been getting RC1-related questions a lot, both via blog comments and directly over email: Will Microsoft open testing sign-ups again when RC1 is released?

Yes.

Will the Customer Preview Program be available for those who missed out on Beta 2 to sign up and get RC1?

Yes.

If I participated in Beta 2 by downloading a PID and the build, will I be able to participate in RC1 automatically?

Yes.

I know you're excited. So am I -- and I'm using a newer build (5505) ! More news when it's available.

Reply:

that's great!

------------------------------------
Reply:

How does one go about ordering RC1. I am using Beta 2 Build 5384. There is a site from MS that will allow you to order RC1, they however want a registration number in order not to be charged again for shipping. I do not know where to find the registration number. I tried the PID but that did not work. I did register Vista but I did not receive any type of registration number.

I then called Microsoft and the person I spoke to could not tell me where to find it. I found that rather amusing. I am beginning to wonder if it is worth the hassle any longer?

Any information on where to find this registration number would be appreciated.

------------------------------------
Reply:

RC1 is not currently available to order. What web site are you refering to when it comes to ordering RC1?

Check out the MS Vista home page.

http://www.microsoft.com/windowsvista/getready/default.mspx

------------------------------------
Reply:

dsljay wrote:

RC1 is not currently available to order. What web site are you refering to when it comes to ordering RC1?

Check out the MS Vista home page.

http://www.microsoft.com/windowsvista/getready/default.mspx

This site:

http://microsoft.order-6.com/RC1_Registration/welcome.aspx

And the site looks like this:

http://s20.photobucket.com/albums/b243/TK-1913/

------------------------------------
Reply:

I would be careful with that site. According to MS, RC1 is not released as of yet but should be released next month. Can I ask where you learned about that site from? I do not see it listed on Microsoft.com or TechNet. Maybe a scam site. Also note at the bottom of the page is a Contact Us link. I would think that it should be @microsoft.com and not @microsoft.catalysis.com but I could be wrong.

------------------------------------
Reply:

This site appears to be a legitimate MS site.

I ordered it and got back a confirmation from Microsoft...

------------------------------------
Reply:

seem that link is so strange...

------------------------------------
Reply:

Mojavekroc wrote:

This site appears to be a legitimate MS site.

I ordered it and got back a confirmation from Microsoft...

Mojavekroc, what did you put in the box in the bottom of the page? I take it it wasn't your serial # from the original email or was it?

Also from my understanding, this is not a Microsoft site. It looks more like a site that wants you to believe it is though. I would be careful entering any personal info into that site since I have yet to see it mentioned on microsoft.com itself or microsoft.com/technet. These days it is to easy to mask an email address to send a fake confirmation to people.

------------------------------------
Reply:

dsljay wrote:

I got the linke from Pronetworks http://www.pro-networks.org/forum/index.php?sid=1ca88a36009c9cc90a936677012865cc

In this thread:

http://www.pro-networks.org/forum/viewtopic.php?t=81391

I think that I will wait and not use this link.

------------------------------------
Reply:

Gary1913 wrote:

dsljay wrote:

I got the linke from Pronetworks http://www.pro-networks.org/forum/index.php?sid=1ca88a36009c9cc90a936677012865cc

In this thread:

http://www.pro-networks.org/forum/viewtopic.php?t=81391

I think that I will wait and not use this link.

Gary1913,

Since this info did not directly come from Microsoft, waiting would be a good thing. Granted by reading everyone's comments on pro-networks it may seem legit, but why take the chance. I would just watch the microsoft web site and they will update it when RC1 is available to order.

------------------------------------
Reply:

That is what I am going to do.

------------------------------------
Reply:

I agree so!

------------------------------------
Reply:

I am using vista beta 2 and have ohishing check the site, and I got an answer that all seems OK. What should I do?

------------------------------------
Reply:

you can order it.

------------------------------------
Reply:

according to: http://tech.cybernetnews.com/2006/08/15/new-vista-rc1-release-date-september-7/

RC1 is to be released sept 7th

anyone able to confirm this??

------------------------------------
Reply:

I doubt the info of that site...it said:

"As of right now it looks like the build will be Vista 5520 which has not had any screenshots leaked as of right now."

I am usig Pre-RC1 and the build# is already 5536. How come the RC1 build# is older than Pre-RC1?

------------------------------------
Reply:

so when is the customer preview re-opening?

i missed out on the last one and i hope i wont on this one.....

is it just around the corner??

i dont think i'll install 5536 then..i'll just wait for the cpp to reopen

------------------------------------
Reply:

where can I get a product key agian? or can i use the beta 2 key i recived?

------------------------------------
Reply:

Consider yourself scammed. It is a phishing website!!! Don't give out your credit card information before at least checking out the domain name. Order-6.com is **not** Microsoft.com!!!

------------------------------------
Reply:

I think MS will anounce it to you. Whether you can use the same key or issue a new key to you.

So, please wait for it.

Thx!

------------------------------------
Reply:

RichardWu wrote:

I think MS will anounce it to you. Whether you can use the same key or issue a new key to you.

So, please wait for it.

Thx!

You can use the same key that you used for Beta 2 on the 5536 Pre RC1 build. I understand that MS will release the real RC1 on Tuesday.

------------------------------------
Reply:

latest info: it was released on the CONNECT site now!

------------------------------------
Reply:

RichardWu wrote:

latest info: it was released on the CONNECT site now!

Yes and it is build 5600

------------------------------------
Reply:

I'm a registered Beta2 Tester and was not able to download any updates past the one Microsoft sent me (5384). I wasn't able to get the pre-RC1 last week. I'm not able to download the Official RC1 that is available for (supposedly) Visat Beta Program testers.

Not so. I guess I failed to record some secret handshake somewhere.

Mike

------------------------------------
Reply:

As the info from the Vista site: http://www.microsoft.com/windowsvista/getready/default.mspx

Windows Vista Release Candidate 1 (RC1) is now available for Customer Preview Program (CPP) participants only. If you are not registered but would like to receive RC1, the CPP will open to new participants in the coming weeks. Please check back periodically for updates. Once you have installed Windows Vista RC1 be sure to visit the Resource Center to download the Windows Vista Product Guide and discover more information that will help you get up and running quickly.

------------------------------------

"Pro SQLCLR 2005 CLR Stored Procedures, Functions, and Triggers" TOC

For those intersted here is our TOC and the book's link. You can preorder at this point. We are sticking to the Nov. timeframe, but we may get it done sooner.

Chapter 1   Introducing SQLCLR
Chapter 2   Building a Procedure
Chapter 3   SQLCLR Strucutre & Common Tasks
Chapter 4   Creating Objects
Chapter 5   Compare & Contrast
Chapter 6   Replacing TSQL Objects
Chapter 7   Using the Base Library
Chapter 8   Using Procedures in Apps
Chapter 9   Error Handling
Chapter 10 Administration
Chapter 11 Case Study

Here is the link:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0470054034.html

Enjoy,

Derek

Reply:

Chapter 4 "Creating SQLCLR Objects" I am trying to get changed to "Creating SQLCLR Modules"...believe Modules is the more appropriate term.

Explores Stored Procedures, Functions (SVF & TVF), Triggers (DML & DDL), User-Defined Types (UDTs), and User-Defined Aggregates (UDAs). After Chapter 4 it is all real-world examples, in 4 we use very simple examples to help reader focus on the concepts first.

Chapter 5 is actually "Compare and Contrast TSQL and Managed Code".

Thanks for the questions, Adam...The more input we get on this the better it keeps getting!

------------------------------------

Query Based DL's Exchange 2007

I feel that the wizard to create query based DL's in Exchange 2007 does not give half the functionality that exchange 2003 gave.

EG where can I paste in a custom ldap query?

Reply:

The wizard for DDG, AL, and EAP all provide the same view of "precanned" filters in Exchange 2007, designed to cover the most common filters and conditions with a straight-forward interface.

If you wish to create complex/custom filters outside of the precanned set, you can use the RecipientFilter parameter at the cmdlet and specify your filter query in OPATH format. There's a bit on the syntax for OPATH RecipientFilter at the wiki already and there'll be a blog post on it in the near future as well.

------------------------------------
Reply:

Great thanks, I like the recipient container option

I hope you dont mind me asking further questions about opath?

1) Where can I get more information about OPATH?

2) What about extensible matching eg

LDAP_MATCHING_RULE_BIT_OR "1.2.840.113556.1.4.804"
LDAP_MATCHING_RULE_BIT_AND "1.2.840.113556.1.4.803"

3) since AD also uses LDAP query, will longhorn also use this new query format?

------------------------------------

HOW TO: Display Dynamic Images

I recently completed a set of reports that required displaying images (small icons) based off of the value in a specific data field. It took me a quite a long time to get this to work as I wanted it to, so I wrote a little 'How To' article in my blog to hopefully save someone else a lot of time!

Dynamic Images in SQL Server 2000 Reporting Services

Note that I don't claim to be an expert SSRS user by any means, and if there is a better method for displaying dynamic images than the method I used, please let me know!

Reply:

I just wanted to thank you for saving my time. Your blog was truly helpful. Appreciate it.

Cheers

preps.

------------------------------------

Announcing the Analysis Services Stored Procedure Project

A few months ago, a few community-spririted Analysis Services guys (including me) got together to create some example Analysis Services stored procedures. I'm happy to announce that beta 1 of our project is now available to download here:
http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASStoredProcedures
The idea was to create a set of useful extensions to MDX to help solve common problems and at the same time provide some example source code to help people writing their own stored procedures. Please take a look and tell us what you think!

Reply:

Very Nice!

How about a function that takes care of divide-by-zero and returns NULL if the denominator is 0? Ie. ReturnDivide(division). That would clean up a lot of iif mdx.

------------------------------------
Reply:

We discussed this exact problem, but Mosha explained that using a sproc in this way would do more harm than good. Basically, the problem is that there's no way of marking a sproc as being deterministic (ie will always return the same result for the same cell) and so that means that if you use a sproc in a calculated member then the value returned by that calculation will never be cached. As a result, it's probably better to use IIF instead so that subsequent requests for the result returned by a calculation for any given cell in the cube will be returned from the cache.

To answer your other question about IIF, if <mdxstatement> is a calculated measure whose result can be cached, then no, it will only be executed once and the second time it's evaluated the value will be returned from the cache. So it's good idea to create a calculated measure to hold the value of <mdxstatement> even if you don't intend to display the result to the user and set its Visible property to False.

HTH,

Chris

------------------------------------
Reply:

Just so I understand:
You are saying that the following MDX script will make the server calculate [measures].[summation] once in the scope iif statement:

Create Member [Measures].[Summation] AS

Aggregate({[DimMember1], [DimMember2]});

Scope ([DimMemberX]);

this = iif([Measures].[Summation] = 0, NULL, [SomeSet] / [Mesures].[Summation];

End Scope;

Whereas this statement will make it calculate it twice:

Scope ([DimMemberX]);

this = iif(aggregate({[Dimmember1], [Dimmember2]}) = 0, NULL, [Someset] / aggregate([DimMember1], [DimMember2]));

End Scope;

------------------------------------
Reply:

Yes, that's what I understand.

Chris

------------------------------------

Windows Vista Beta

I test this time Windows Vista beta programm and must ascertain there are many problems with it.

1. programs one instal function only once shortly after the installation and if one sometimes the PC restarts functioned nothing more.

2. it would be very nice if one could reduce the desktop icons according to him like one would want it.

3. hardware of the PC recognises or which he cannot instal.( WLAN STICKS )

4. If it seems to me very funnily that I cannot find many things ( How the CD and DVD disk driver explored )

5. And it is funnily one only one quite certain virus program can be of use. And another program is not even recognised.

I know this a lot of things are I would have with pleasure an answer to it

Ralf

Reply:

Thanks for posting Ralf. A lot of these questions can be easily answered, but this forum is for questions concerning Exchange Server 2007. If you scroll down to the bottom of the forums topic listings you will see the Vista IT Pro forums where questions regarding Vista can be better answered.

------------------------------------
Reply:

Well actually this forum is for Windows Server "Longhorn", not Exchange Server 2007, but the point is the same :-)

This is the right link to see the full list of TechNet Forums.

------------------------------------

Ms Support forum

Saturday, April 2, 2022