Saturday, April 2, 2022

Gadgets problem

Gadgets problem

When I load the Sidebar after a reboot, I can click on the "+" to add Gadgets to the sidebar and they appear to work fine.  If I remove the gadget using the "X" beside the gadget, it disappears as expected.  Then, if I click the "+" again to add that gadget back to my sidebar, the gadget doesn't appear to work.

For example:  If I remove the clock and then add the clock back, the hands don't appear.  If I remove the slideshow and add the slideshow back, the images don't appear.  If I remove the puzzles and add them back in, they are blank.

Once I reboot, it works for the first time until I remove each individual gadget.

This doesn't appear to be a problem for the calculator, stocks, notes or feeds gadgets.

Has anyone else run across this?  I know it's minor, but it is still a bug.


Reply:

I can kinda reproduce the bug...

If I take the clock off and then add it back onto the sidebar, the two big hands show up, but no second hand. Additionally, the time seems to be stuck for a minute or so before it gets updated.


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

Yes, this is a known issue. It was going to be included in the release notes but it got bumped from that file by more serious issues.

 

The Clock, CPU, and Timer gadgets are known to be affected. At this time, there is no workaround other than to close and reopen the affected gadgets.

 

vv

J.O.


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

Dimension dinamic for time SQL olap

goog morning


I need collaborate in like handling the following subject to me:
 I have a dimension Product that crosses the Dimension Market. According to the time the product, the product is considered present or new.
 Example:
 01/01/2005 product is new 
01/02/2005 product is new
01/01/2006 product is new
01/02/2006 product is new
 01/03/2006 product is Present and seguira present as of that date.


Until I do not have problems. For month, the dimension is recursive for the time 

The problem appears when I observe the product and its sales in a period of the accumulated time.
 The sales of that product in accumulated periods must assume them member of the dimension of market
 according to I complete month of the observed trimester osea present market

 Example: first trimester of the 2006
value like new(enero and febrero  2006) and
 value like present(ventas for March).
I need that for accumulated periods,
the value of I complete month of the trimester (March is (actual)). and returns all the sales to me of that trimestre  like present market and not divided market in two memebers($ present and $ new).
 
 
thanks for your collaboration

DNS - Bugs

I've found 2 bugs in vista beta 2 (build 5384) 64bit edition regarding DNS.

1) Wireless adapter using DHCP will incorrectly assign DNS ip address 192.168.1.83 insted of 192.168.1.8. (work arround, disable and enable, it will pick up the correct ip)

2) dns lookups do not work first time out. but eventually will (3rd time usually). This eventually leads ie7 not to load pages. If you let IE wait and time out, it will never connect back to that site at least in 2hour period. (only work arround I've found is to stop the page from loading 5-6 seconds after initializing load, reload, repeat until it loads)

Hope fully these will be resolved shortly.

 


Reply:

Jccondor,

If you believe this to be a bug, please post a bug report directly to MS so that it can be investigated and fixed.

It has been observed that Vista does have some issues obtaining a valid IP address from DHCP. Disable and re-enabling the NIC usually resolves the problem (regardless of WiFi or fixed NIC).

HTH.


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

I've tried. After several hours I gave up. Couldn't find how to report the bug. (so much for beta testing)

If any one has instructions on how to submit bugs...


------------------------------------
Reply:
There is an icon on the Vista desktop that provides instructions on sending feedback in a default installation.

Check that out and let us know if it helps. Thanks.

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

I'm not sure what happend(maby I deleted it) I only have one Getting Started. I've clicked on it but can't find submit bug. Please post where the link points to...

Thanks,


------------------------------------
Reply:
Here you go (related post to send feedback):

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=464740&SiteID=17
 
Please let us know if this helps. Thanks.

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

The fastest way to stop SQL Server 2000 without admin permissions... (Bug)

 

Do You want to stop the SQL Server service without admin permissions ? Use this Code :

CREATE TABLE [dbo].[stop_service] (
 [NUMBER] [int] NULL ,
) ON [PRIMARY]
GO

INSERT [dbo].[stop_service](
 NUMBER
)VALUES(
 CONVERT(numeric,43459855,43459855)
)
GO

I've tried contacting Microsoft to report this bug but only subscribers can do...

Don't run the code above in a production environment !! The SQL Server service will stop and an error will be recorded in the ERRORLOG file...

Does anybody know how to submit this error ?


Reply:
You are encountering an access violation that brings down the SQL Server service. You can file a bug at http://connect.microsoft.com. Please attach the dump files generated by the server, errorlog along with the bug report. Btw, the above code will not necessarily have the same effect on other SQL Servers. It can be something specific to your environment, even a corruption in the database and so on.
 
What version of SQL Server are you running? Do you have to latest service pack and hotfixes applied? For SQL Server 2000, it will be SP4 and SP2 + Hotfix package for SQL Server 2005. Start with doing DBCC CHECKDB on the database to check for corruptions. Can you repro it on any other server? If there is none, then apply the latest service pack.

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

 

I found this bug in a production environment that is running Windows 2000 Service Pack 4 with SQL Server 2000 Service Pack 4 (8.00.2040). I executed the code of the previous message in 4 other servers  and the results are the same, the SQL Server goes down.

I tested the problem on a Windows 2003 box with SQL Server 2000 Service Pack 4 + KB-916287 (8.00.2187) and the problem hapenned again.


------------------------------------
Reply:
Thanks for posting the version of SQL Server. It was helpful for repro purposes. I was able to reproduce the problem on 8.00.2162 build of SQL Server. I will let you know if I find anything more regarding this problem.

------------------------------------
Reply:
Btw, for now the workaround is to use the correct syntax / parameters for CONVERT function like:
 
INSERT [dbo].[stop_service](
 [NUMBER]
)VALUES(
 CONVERT(numeric,43459855)
)
And the convert itself is unncessary since the column is integer and you are converting integer value to numeric and back to integer. Or your repro is simpler than what you actually have. In any case, if it is due to the convert then using the correct syntax will eliminate the AV.

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

Thanks for Your help Umachandar,

I don't have control over all statements executed in our servers and I'm sure that there are unnecessary conversions. The main problem here is that based on this bug somebody can create a program that submit a malicious code and easily stop the service.


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

Need help to write a MDX formula for % OF calculation

I am working with Hyperion, but the MDX language is the same so I think someone here can help me.

I have a cube that tracks a Dollar Value (FACE) accross like 10 different dimensions. I need to write a formula that calculates % Face of Total for ANY possible combination of the dimensions.

In short it looks like this:
[FACE] /
([FACE],
[PORTFOLIO].CURRENTMEMBER.PARENT,
[ACCOUNT].CURRENTMEMBER.PARENT,
[MANAGER].CURRENTMEMBER.PARENT,
<<MORE DIMS HERE>>
).VALUE * 100

The problem is that if I am at the top level (Gen 1) of any of the dimensions, the tuple returns a 0 so I do not get a result until I zoon in on ALL the dimensions. What I basically need to do is build in logic that looks like so:
IIF ( ISGENERATION ([PORTFOLIO].CURRENTMEMBER,1), [PORTFOLIO].CURRENTMEMBER, [PORTFOLIO].CURRENTMEMBER.PARENT)

The problem is that I can not put the IIF statement inside the tuple and with 10 or so dimensions it creates too many posibilities to put the IIF statement outside the tuple.

Any ideas on how I can maybe use variables or something to do this??

THANKS!!

Installaion (Boot from DVD) Won't Allow me to choose HD - Works running setup within XP

Want to know if other people have come across this.

Windows Vistia x32 DVD Beta 2

I booted from the dvd, and it kept insiting it wanted to use Disk 0 because it had enough space to intall vistia and wound not allow me to choose the Vistia partion on Disk 1 I set aside.

It did work when I ran setup from within Windows XP.


I have 3 Hard drives install.

(Disk 1) SATA split in to 3 100 gb partion
(Disk 0) IDE Western Digital 150 GB set as one big partion
IDE Western Digital 40 GB set as one big partion

SATA boots 1st (Vistia did detected SATA drive w/o any problem).

Did anyone else come across it insiting what drive it wanted and not allowing you to choose when booting from the dvd?

Reply:

you need drivers for sata for vista to boot

What you'll need to do is make a copy of the SATA Drivers and put them in the Root of a Floppy so that the Vista Install can grab the necessary drivers.

then you need to make sure that bios of computer is set correctly 


------------------------------------
Reply:
It allowed me to see the SATA partion(s) w/o the use of SATA driver disk (booting off dvd)

When I installed from within XP I also didn't require any driver files.

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

dimension dinamic sql olap MDX

goog morning
I need collaborate in like handling the following subject to me:
 I have a dimension Product that crosses the Dimension Market. According to the time the product, the product is considered present or new.
 Example:
 01/01/2005 product is new 
01/02/2005 product is new
01/01/2006 product is new
01/02/2006 product is new
 01/03/2006 product is Present and seguira present as of that date.
Until I do not have problems. For month, the dimension is recursive for the time  
The problem arises when I observe the product and its sales in a period of accumulated time. The system returns of that accumulated period whatever to me were the sales like new and whatever like present.
 Example: first trimester of the 2006
value like new(enero and febrero  2006) and
 value like present(ventas for March).
I need that for accumulated periods,
the value of I complete month of the trimester (March is (actual)). and returns all the sales to me of that trimestre  like present market and not divided market in two memebers($ present and $ new).
 
 
thanks for your collaboration
 

mode function

Hi,

Does anybody know how to calculate automatically the mathematical function MODE in a cube using an MDX expression and store it as calculated member?

Thanks for the help!

How to set MDSCHEMA_PROPERTIES.PROPERTY_CONTENT_TYPE and MDSCHEMA_LEVELS.LEVEL_TYPE?

Hi

In AS2005 we could set DimensionAttribute.Type.

What effect does it have on the value of the following fields:

MDSCHEMA_PROPERTIES.PROPERTY_CONTENT_TYPE and MDSCHEMA_LEVELS.LEVEL_TYPE

that are only accesible with MDSCHEMA_ discovery queries?

Are there another way to get information about DimensionAttribute.Type?

What is the exact functional dependensy between DimensionAttribute.Type and
both MDSCHEMA_PROPERTIES.PROPERTY_CONTENT_TYPE and MDSCHEMA_LEVELS.LEVEL_TYPE

 

Jobs on the SQL Server Integration Services team at Microsoft!

Would you like to help realize the vision of making Microsoft SQL Server Integration Services the most powerful and reliable data integration platform in the world? Would you like to come in every morning knowing that the work you do today will impact thousands of companies all around the world, on hundreds of thousands of computers, from desktops to datacenters? Are you looking for a role on a team that empowers you to influence every aspect of the product, from technical implementation details all the way up to vision and strategy?

If you answered, "Yes!" to any of these questions, the SSIS team at Microsoft is looking for you! Here are a few of the positions we're looking to fill, now:

If you think you're the right fit for any of these positions, or if you've got talent that you think could help us in a role we haven't thought of, yet, get in touch with our recruiter, brynam ~at~ microsoft ~dot~ com.

Thanks!

Cim Ryan
Test Lead, SQL Server Integration Services

Arithmetic Operation with Dates

Hi I'm trying to get the difference between two dates. I need to create a Calculated member to show it. I'm using this formula

                        PeriodDays = LastDate - FirstDate

For example, I have a Time Dimension, I choose two dates:

       FirstDate = 07/04/2006 it's identity is 300

      LastDate = 15/04/2006 it's identity is 308

                       PeriodDays = 308 - 300 = 8  this value I need to show in a Calculated Member

The Time dimension has three levels

     Year, month and date

What happens when I choose only a month?

Thanks


Reply:

Dear,

I dont understand onething u are talking about date diffrence and u are giving an identity example.

Pls explain in detail.

Regards

Sufian


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

Hi, ohh, I will try to explain again

I need to get how many days are between two dates, For example, I choose two dates from my Time dimension

Date1 = 07/04/2006

Date2 = 15/04/2006

Days = Date2 - Date1 = 15/04/2006 - 07/04/2006 = 8 days and this value I need to show in a Calculated member

Is it possible?

My time dimension has three levels

Year, Month and day

Can I do this operation, with the month level?

Regards

Thanks


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

SQL Server 2000 - Format Date fetching different dates for each run

Hi Guys,

I have created some reporting services reports using MDX and it was working fine for the last two years. Suddenly one of my queries which fetches current date/ previous day from system is not in consistent values for every run.

Select
{(strtomember("[Time].[JC].[JC Day].&["+ format(Date(),"m/d/yyyy" )+ " ]").prevmember )}on Rows,
{[Measures].[Primary Sales Tons]} on columns
from [Primary Sales]

This query should give me yesterdays date which is 20060703 always. For first time I run this query on the MDX sample application i Get 20060406 ( which is considering today as 20060407 in YYYYMMDD format).

The second time I run it gives the correct date.. 20060703.

I am running SQL server 2000 with SP4 applied.

Can any one help with this.

Thanks & Regards

Ram

 

 

 

 

 

Multiple items working the wrong way?

Hi,

I have created a standard dimension with several items, when  i analise the values for one of each items the values are correct but when i choose multiple items the value always comes null... why it doenst shows me the SUM of the selected items?

Imagine:

Item 1 : $500 ( It returns ok )

Item 2: $500 (It returns ok )

Multiple items (1,2): $1000 ( It returns Null / Empty )

It seems to me that this is another AS Bug... Anyone experiencing this problem?

 

Best Regards,

Luis Simões

MDX Statement create CalcMemebers

Hello together,

 

I want to get the value (Measure) of a Cube "4711", and this Value I want to display in an other Cube "XY" as a CalcMember.

Do you have an idea for the rigth syntax???

MDX: Reference ROOT when subcube is used (database totals)

I am trying to create a calculated member that returns the database (not visual) total of a measure.

CREATE MEMBER CURRENTCUBE.Measures.Test AS ([Measures].[Purchase Value], ROOT([Supplier])

Now, this works in the following query

SELECT [Measures].[Test] ON 0,

[Supplier].[Supplier].[Supplier].Members ON 1

FROM Analysis

WHERE [Supplier].[Supplier Group].&[3434]

But when the query is executed using a subcube:

SELECT [Measures].[Test] ON 0,

[Supplier].[Supplier].[Supplier].Members ON 1

FROM (SELECT [Supplier].[Supplier Group].&[3434] ON 0 FROM Analysis)

.... Analysis Services applies VisualTotals and my calculated member is the result of the total for the supplier group specified in the subcube statement.

I cannot control the behavior of my client application, which builds the query using a subcube, so I need to specify my calculated member in such a way that it is able to 'look outside' the subcube and return the database total.

How can I do this?

PivotTable - Expanding a member for details retreives all other member details!!

Hi, Am using OWC 11 PivotTable Component and I have noticed the following behavior while using pivotTable lists.

The issue is that whenever I expand an item, the pivotTable will retrieve and apply the calculation for all siblings of the expanded items eventhough, it keep them unexpanded. It seems that it always cache all members in the level I have expanded to.

I also noticed that at the last level of the hierarchy the data retreived will be limited to the item am expanding to.. which is the behavior i want no matter what level am expanding to.

I used profiler to grab the queries generated. I noticed that when the expand indicator is clicked the query will retrieve all members: A.B.members while in the second case where am drilling down to the lowest level the query uses the descendants function: Descendants(A.B.&[expandedMember], levelAmExpandingTo)

I wonder why it is behaving like that... it is really hitting the performance and bandwidth by retrieving data that i may never look at.

I hope there is way to force it to use the Descendants function so the data retreived is only the data for the member being expanded.

Thanks in advance.

 

After you have downloaded Windows Vista Beta 2, you get an icon or image of a blank piece of paper.

 

 For those of you who have downloaded Windows Vista Beta 2 version is discovering an image or an icon that looks like a blank piece of paper thinking that it was a bad download. Technically, it is not, unless otherwise you would have gotten a message during a download reading something like "Cannot download" or the like. This image or icon of a blank piece of paper is actually an ISO image which must be converted through the DVD burning process. After the DVD burning process is completed, if you look on your DVD by inserting it in your DVD player, you will see a different icon or image if you will, it will appear as an opened package with a CD sitting in front of it. When you see that, you will know that you do have a good downloaded copy. 

  For some of you complaining of the Windows Vista freezing up on your computer is usually associated with the hardware fixtures. You want to make sure that your primary hard drive is jumpered to Master. Another problem could very well be is by changing the ribbon cable to a new one located on the back of your hard drive. Also make sure that the DVD player is hooked up in either way: 1st option: Set the DVD player to Slave by moving the jumper in the back of it and plug in the same ribbon cable that the hard drive is on. 2nd option: Make sure that the DVD player is set to Master or "MA" (imprinted on the back of it.). Plug the second ribbon cable up to it and make sure that the other end is plugged into the Secondary slot on the mother board. That should resolve the freeze up problem. If you have the DVD burner hooked up in there, unplug it completely until the Windows is fully loaded on and then you can re-configure everything back to the way they were. Hopefully that will solve the problem for you. Good luck!

SSAS2005 Actions

Dear all,

After spoiling a day i think it is better to ask for help.

I created a hetrogenious cube in AS2005 with more then 30 Dimension and 3 Time dimension (time and system dimension).

2Days back the user given me a requirement the on purticulat vedor dimension i want to see vendor profile.

So i cretated 2 actions (Action and Report Action).But when i process the cube i cant see the action anywhere.

I created the action on dimension and in condition i had writen these lines

iif([Product Vendor].[Vendor ID]>65,-1,1)

and given the URL.

But again i process the cube i cant see the action.

I connected to Analysis services through management Studio .But still i have nothing in my hand.

SP1 already installed for all services.

Pls help me in this regard.

This is the XML Command of the report action

<Actions>

<Action xsi:type="ReportAction">

<ID>Report Action</ID>

<Name>ShowReport_Vendor_id</Name>

<TargetType>Hierarchy</TargetType>

<Target>[Product Vendor].[Vendor ID]</Target>

<Condition>iif([Product Vendor].[Vendor ID]&gt;1,-1,1)</Condition>

<Type>Report</Type>

<Invocation>OnOpen</Invocation>

<Application></Application>

<ReportServer>svr_test\sql_2005</ReportServer>

<Path>http://svr_test/ReportServer$SQL_2005/Pages/ReportViewer.aspx?/Matrix&amp;rs:Command=Render</Path>

<ReportFormatParameters>

<ReportFormatParameter>

<Name>rs:Command</Name>

<Value>Render</Value>

</ReportFormatParameter>

<ReportFormatParameter>

<Name>rs:Renderer</Name>

<Value>HTML5</Value>

</ReportFormatParameter>

</ReportFormatParameters>

</Action>

from

mohd sufian

How can I destect if a member exist in an other hierarchy of the same dimension ?

Hy,

I have a dimension (unit) with two hierarchies.
I would like to condition a calculation by testing the member existing in the other hierarchy.

How can I destect if a member exist in an other hierarchy ?



Georges

SCCP now available to MSDN subscribers

We're happy to announce that System Center Capacity Planner 2006 is now available to MSDN premium-level subscribers! It went out as part of the March 2006 shipment; you can also download it directly from Subscriber Downloads (under Servers/System Center Capacity Planner)

System Center Capacity Planner 2006 employs state of the art modeling technology to bring unprecedented functionality and flexibility to the process of performance analysis and planning of Microsoft Exchange Server 2003 and Microsoft Operations Manager 2005 deployments. With System Center Capacity Planner the IT Professional will get the guidance required to plan a deployment in the most efficient manner, while also allowing for "what-if" analysis for future planning.


Reply:
That is great.  Though unfortunately, even though I am an MSDN subscriber, the download is still not available to me.  Is there a link that you could send to me? 

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

Hi mindcube - the instructions I've been given are "from MSDN Subscription Management go to Subscriber Downloads and Product Keys, then the path is Servers\System Center Capacity Manager\System Center Capacity Manager 2006 (English)."  Subscription Management's URL is: https://msdn.microsoft.com/subscriptions/account/managesubscription.aspx

You could also try this direct URL - let me know if it works for you. https://msdn.one.microsoft.com/home.aspx?ApplicationID=3FF5C83B-C145-4388-BA64-F94B1F31946A&CultureCode=en-US&SourceSystemCode=XEN&BenefitDetailGuid=120C6FFC-A8C2-4C81-975B-6DA0A86BFB50&AccessGuid=0B2619F0-3DB9-4F09-B242-196722806B1A&SubscriptionStatus=Active


------------------------------------
Reply:
Hello there,

neither of those links work.  Is the SCCP available to every type of MSDN subscription?  This tool would be invaluable to us as we are planning an exchange upgrade soon...

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

 mindcube wrote:
Hello there,

neither of those links work.  Is the SCCP available to every type of MSDN subscription?  This tool would be invaluable to us as we are planning an exchange upgrade soon...

Hi mindcube - we're actively trying to track down this issue. Can you confirm that you can get to the MSDN Subscriber Downloads page? If so, what do you see when you expand the tree control on the left of that page, to drill down into the Servers category?


------------------------------------
Reply:
Update: we've identified why some MSDN subscribers aren't seeing the download, and we're working with two other groups to get the problem fixed. I'll post again as soon as I have any more information.

------------------------------------
Reply:
Update: Sorry for the mess-up here, guys. SCCP is only available to premium-level MSDN subscribers.

------------------------------------
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...