TV Anywhere Plus - No Video

When I first installed the TV Anywhere software I was able to start the program. I was able to get sound however the video screen was blank. When I checked Windows Media Center I got exactly the same result – sound but no video.

After removing the application, utilities, BDA drivers, and uninstalling the card I started over again. The card installed with no issues (Note: It is utilizing newer drivers than my Vista Ultimate 64bit system). I then installed the TV Anywhere utilities and BDA drivers - again no issues showed up. Prior to installing the TV Anywhere application I decided to try Windows Media Center and was surprised with a good picture and sound. The only problem was that I couldn't figure out how to change to a 16x9 format to match my LCD monitor.

As soon as I installed the TV Anywhere application I once again lost the Video on Windows Media Center (and got no video on TV Anywhere) however didn't lose the sound. The only way to get the video back on Windows Media Center was to remove everything once again and start from square one. On one of my tests however I muted the volume on Windows Media Center prior to trying to install the TV Anywhere application and even though the video screen went blank after I installed TV Anywhere I could still see the scrolling text on the video screen ??

Changed type Ronnie VernonMVP Saturday, February 7, 2009 12:11 AM No response

Sending a mail in a Data Flow

Hey All,

I see the task send mail in Control Flow, but cannot see this option in Data Flow.

I have a data flow which contains a Look Up which determines if the data should go for an Update or Insert.

Now when I perform an insert (This would represent a new user) I would also like to send an email straight after.

How Could I achieve this ?

Reply:

I think this should be possible using a script component.

Try this link. It's an example of how to send an email from a script TASK, not COMPONENT, but I think the concept should be similar, except that in a COMPONENT you are sending the email each time a record passes by.

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

Velnias,
There are a few different ways to do this, more than the two I mention I'm sure. I have a few packages that need to send emails resulting from a data flow task, so I normally do one of two things. Have a data flow destination that is a variable (type object) I then loop through the object outside of the dataflow latter on the package sending an email for each row in the record set object variable. Or I have a script task destination inside the data flow and use a FireInformation event. I then have a event handler for onInformation for the package where I catch the onInformation event and send an email using information that I have passed inside the information event as parameters for the email. I do different things depending on circumstance.

Steve Fibich

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

ffftw_ayi

I couldnt see a link in your post ?

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

Velnias said:

ffftw_ayi

I couldnt see a link in your post ?

Sorry...

http://blogs.conchango.com/jamiethomson/archive/2006/07/03/SSIS_3A00_-Sending-SMTP-mail-from-the-Script-Task.aspx

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

Velnias said:

Are you sure this is what you want to do? Do you want to send an email for EVERY row that gets inserted? If not then you don't want to be doing this from inside a dataflow.

If you want to send an email IF there is at least one row inserted then capture the number of rows inserted using a Rowcount component and then fire off an email using the send mail task if the number of rows > 0.

-Jamie

http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson

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

Hey Jamie,

Yes this is what I want do let me sort of draw it out so I can explain better.

So...

DB Source (5 Records)

Look Up (3 Records Remaining - These are new records and need to be inserted)

Script (Send 3 emails to each of the records individually i.e each record has an email)

..

Can you see any problems with that Jamie ?

Thanks for your help by the way

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

Velnias said:

No, no problems at all. The link provided earlier should give yuo everything you need.

http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson

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

Excellent Ill mark that as answer for now, if i come across any issues ill pop them in here

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

I have an issue with using the Email Script in the using the script component in the data flow.

It has to do with this line

Dts.TaskResult = Dts.Results.Success

Where I have the following includes

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net.Mail

Imports System.Net

The error I am getting is

Name 'Dts' is not declared

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

Velnias said:

I have an issue with using the Email Script in the using the script component in the data flow.

It has to do with this line

Dts.TaskResult = Dts.Results.Success

Where I have the following includes

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net.Mail

Imports System.Net

The error I am getting is

Name 'Dts' is not declared

Yeah, that's very true. Components and tasks work in different ways and do different things so you can't expect that you can just pick up code from a script task, drop it into a script component, and everything will miraculously work (unfortunately).

Still, it doesn't matter for you. In your case those lines of code that begin "Dts." are superfluous anyway in the context of a script component. Just get rid of them.

http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson

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

Hey Jamie,

Thanks for that I did some reading up, seems like in script components the word 'me' replaces 'dts' for a lot of features.

I have another question regarding the email script.

Before I go to the email component I would like to add a step to generate a random password.

i.e from

DB Source (5 Records)

Look Up (3 Records Remaining - These are new records and need to be inserted)

Script (Send 3 emails to each of the records individually i.e each record has an email)

to

DB Source (5 Records)

Look Up (3 Records Remaining - These are new records and need to be inserted)

Add new column - Password

For each records generate a random password

Script (Send 3 emails to each of the records individually i.e each record has an email and include the password in the mail)

How would i go about this

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

SSIS has nothing in built for generating random strings but I'm sure that .Net has something in it that could do it which you could then throw into a script component/task. Given that this is a SSIS forum not a .net forum you're more likely to find an answer to this elsewhere.

http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson

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

Ok even set aside the random password...

Im more worried about the logic in the SSIS

For example first thing I wish to do is

1) Add a new derived column i.e password but when I do so it asks for a expression. What expression do you enter if you simple wish to add a new column.

2) If i add a script component to set a value for the password. Will each record go in their or will it only go past it once i.e if i set the password value to something random. Will each 3 have a different value for password or will all 3 have the first ?

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

Velnias said:

Assuming its a string....
(DT_WSTR, 20)""

will put an empty string into a unicode field of length 20

Velnias said: 2) If i add a script component to set a value for the password. Will each record go in their or will it only go past it once i.e if i set the password value to something random. Will each 3 have a different value for password or will all 3 have the first ?

That's up to you. You can do either.

http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson

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

I would like the each one to go in seperate so i.e 3 different password values get set, what should I do for that ?

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

Velnias said:

I would like the each one to go in seperate so i.e 3 different password values get set, what should I do for that ?

Row.<column-name> = <generated-value>

Intellisense should tell you all you need to know. just type "Row." and let it guide you!

http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson

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

Ok Jamie, ill play around with his now.

Thanks for your help again

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

Ok 1 thing i have a question..

When I decide wether its an insert or update, i wanna put an additional split in my update.

I.e i wanna check if a particular column is 0 or blank and if so i either update or insert something else.

What the best component to use to check the value of a column and have two arrows coming out of this component

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

Velnias said:

Conditional Split component

http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson

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

Setting Up Media Centre Gives BSOD

Well the title says it all really
my AVerTV DVB-T USB 2.0 (A800) ran fine under vista
in fact vista went and found the drivers and i had no input in setting it up

anyway is this a issue pacific to my card or is there an issue with media centre in general?

Moved by Othorvath Saturday, January 17, 2009 8:46 PM (Moved from Windows 7 Miscellaneous to Windows 7 Media)
Changed type Ronnie VernonMVP Saturday, February 7, 2009 1:29 AM

Please consider for start menu task options... Time to really upgrade.

I think the real key Microsoft really needs to under stand is this! It's time for a real change. The whole start group is boring, not customizable enough for everyone tastes, and again boring with to many options for a typical user to even understand. Many of your customers get intimidated by the vast options, so closely spaced etc. This is why many users have switched to the Mac Desktop. It's really easier for them and to the point.

I think the start button should be slightly enlarged circle icon and kept at bottom left. Keep the task bar but consider a groups options with your preview option. Example when you select properties on a program, allow selecting an option group in the tabs say 1 - 6 . (other programs no option selected would just min typically with your current format.)

If you have 5 programs running selected to option 2 and they are minimized they are kept together in that one task bar icon. The preview then will show those 5 programs grouped. This would have HUGE benefits to the commercial side of your business and even home users. Imagine instead of 5 icons, having 1 for very quick switching with a screen shot preview of each, no more hunting, or tab'ing 12 apps. Fast.

As for start button.

Upon execute. Screen shades very faint black transparent tint. (Visual option setting could turn off shad effect but would look cool, adds class.) This would not cut off access to the desktop for drag drops, etc, just a slight color tint overlay.

Center top, or bottom of screen a box with larger icons should display (I know kind of a OSX like, but very improved). Upon click or hover (option setting, plus scalable icon size that scale or genie effect on hover options, w, w/o text, etc.) sub levels will expand up or down the screen.

(Also when the bottom or top loads, left or right side of screen should load a box with your recent/shortcuts, My documents folders, etc. Menus should be customizable but default set with the inexperienced user in mind. Inexperienced = documents, audio, video, folder, etc. Basics.)

****

* *

****

************************

**** * *

Start * Start Menu *

**** ************************ active icons | clock.

Upon selection of an icon in these groups the group would expand up/out/across and so forth.

The key is style, efficiency, and functionality while also making it easier for the other users. Slapping graphics and pretty colors does not do the job. Sometimes the smallest changes make the largest impressions. A user wants simplicity, style, and function. This layout is the fastest (minus shortcut =) and will offer your struggling users larger images, without the clutter the usually newer style menus have featured.

If MS is interested let me know and I will better detail my ideas, beside my crudeness above :)

Theres nothing wrong with the task bar

I had to say it, people complain about not having quicktabs or what ever, if you want it like vista, just right click go to properties, than change taskbar buttons to never combime, than its just like vista, you can even make the taskbar smaller to make it look like vista. the apps are only spaced out because its easy to use on a tablet

I kinda wish the stuff on the rightside had color to it

Reply:

doing what you say hardly makes the taskbar behave like vista :(

you will still end up with shortcuts interspersed between active windows....

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

Unpin everything and add a toolbar. It's really not that hard.

But I agree with HDadam. The smartbar is a huge improvement over the classic taskbar.

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

I think they need to make the context menus on the right of the task bar, and the whole OS, like the context menus on the task bar with the white background and transparent border.

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

i have no idea why people complain about not having the classic "grey" toolbars and menus. They were always ugly in my eyes. People keep complaining that windows is so far behind osx and linux and never updates. so they did, now everyone complains about it.

I personally love the smartbar. I like the hybrid "taskbar/dock" concept.

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

Agreed... disable combining, set it to small icons, and unpin everything, and voila-- Vista Plus! UI is yours (still featuring Drag-and-Drop organization).

But frankly, the new method is fantastic, and I won't give it up for the world!

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

but you have to August 1st ;)

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

Bah. If I can't get the Win7 Release Candidate then I'll just stop using my computer until the retail version comes out. No way am I going back to Vista.

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

plz...don't speak of that date...

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

try this instead:

#1 right-click the taskbar -> uncheck "Lock the taskbar"
#2 right-click the taskbar -> Toolbars -> New toolbar
#3 type the following into the "folder" field - "C:\Users\username\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch", where username is your user name on your user account.
#4 click 'Select folder'.
#5 now you can rearrange the Quick Launch into it's classic position.
#6 right-click the Quick Launch and uncheck "Show Text". right-click again to uncheck "Show Title".
#7 size the title-less and label-less Quick Launch area to your liking.
#8 right-click the taskbar -> check "Lock the taskbar"

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

The only problem with the new taskbar is that it is needlessly difficult to set it up the way I want it. It takes the eight steps above to accomplish. All MS has to do is put the Quicklaunch Toolbar back into the toolbar menu, where it has been for years.

That way you can easily use *your* preferred settings, and I can easily use *my* preferred settings. Everyone is happy.

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

I like the new taskbar-just requires some getting used to-big deal. Theare some things that could be better such as code to sep out active from inactive. But let's move forward. I love XP, but it is old, tired and bloated. Vista is newer but super bloated.I look at Vista as a longer lasting ME-a really good transition from a decade of XP to Win 7 and beyond. I have Vista in 1 comp, and it will stay even after Win7 release-I have gotten to like it and know it. One desktop and my laptop will Win 7 when it comes out as they have XP

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

Windows 7 Asus K8VSE, AMD 3700 64 2 G's Ram

I have mounted Windows 7 on a separate 500G hard drive. My system is an ASUS K8VSE-DELUXE motherboard, AMD 3700-64 processor with 2 G's of Ram and 2 500G hard drives and on 160 G hard drive.

The ASUS K8VSE board has an inboard IDE port. It is not bootable. I have a back up drive (500G) on this drive and Windows 7 on another 500G drive.

Installation went without any problems. On reboot, Windows 7 went a got the drivers for my Acer 22" monitor, my ATI X800 256 AGP Pro Video card, and my USB Hub.

Windows 7 also instaly recognized and set up my dual moitor display.

Micrsoft Flight Simulator 2004 runs flawlessly, as does "The Simpsons Hit n' Run" game.

Mozille Firefox also runs flawlessly. I cannot however get the web pages to expand to widescreen, a little annoying.

The legacy AVb USB Joystick was not able to function at all.
I purchased a LogiTech Evo which installed flawlessly, so all is now fine. I think it would behoove Microsoft to come up with a generic program for joysticks. This wouldn't be so difficult.

Idea for Themes

When using the wallpaper slideshow to change the image, it'd be awesome if the glass color automatically changed with the wallpaper, so the glass color always matched with the background. I'm thinking it should do this similar to how the taskbar picks a highlight color for buttons when you mouse-over: it matches the color of the icon.

Reply:

Hi,

Thank you for your suggestion. I will forward it to our feedback team.

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

This would be a great feature and I would recomend it a lot. Please do this by making the color of the theme match the higher color of the wallpaper. I thought of this earlier and sent a feedback but the problem with "Send Feedback" that you don't know if someone would do something with it or the progress of it's inclusion of if it would ever be done.

Please, Please, Please add this feature in an update.

Thanks a lot

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

I agree. This would be a really great little perk!

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

Installation fails

Hi all.
I attempted to install Windows 7 on 2 computers, failure on both. These pc's have 3 things in common. An AM2 processor, a sound blaster sound card and sata hard drives. Both have 3 G of memory. I did a clean install on both. It seems to set up fine then freezes at Starting Services on both pc's.

I got another pc out, totally different from these 2, it's a dell 4600 and everything went fine so I know the setup files are fine. It didn't install the video drivers and when I used the XP drivers from Dell, I got a msg that the operating system was not compatible so installation did not continue. I then got the "did this program install correctly" msg from Windows, I chose no and it seemed to modify it (I didn't think to copy the msg) and the Dell driver installed fine. I'm going to set it up on another Dell and will make a note of the msg.

Any thoughts on the installation failure with the other pc's? I would like to install it on one of the two.
Thanks!
mindy

infinite recursion problem

i am having one script;

SCOPE([Accts].[VACANCY]);this=IIf(ISLeaf([Struct-Funds].[ParentEntity].currentmember) OR ISLeaf([Struct-Orgs].[ParentEntity].currentmember),[Accts].[VACANCY],(((([Accts].[8005ZZ],[Measures].[Value])/([Accts].[8005-00],[Measures].[Value]))+(([Accts].[8008ZZ],[Measures].[Value])/([Accts].[8008-00],[Measures].[Value])))+(([Accts].[8018ZZ],[Measures].[Value])/([Accts].[8018-00],[Measures].[Value]))));END SCOPE;

where Accts is Account Dimension
Struct-Funds is Entity Structure dimension.

I am having one account VACANCY and script for customm rollup calculations for account
VACANCY is as above.
now my VACANCY account is recursively used there in account '8005ZZ' and '8008ZZ' and
this is causing me recursive error while calculations
Error: Infinte recursion detected:...............

So is there any workaround is there to handle recursion in SSAS 2008.

Thanks

Ani

Reply:

Hi Aniruddha,

here's an idea.

Introduce new measures (they will be your flags: VAC, ZZ5, ZZ8) and give them initially zero values, before scopes for VACANCY and accounts 8005ZZ and 8008ZZ.

Inside scopes put additional things. First, make an outter iif() to handle flags.

In the VACANCY scope ask if ZZ5 (and ZZ8 optionally, depending in how many scopes do you have recursion) are 0. It means that those scopes haven't fired. If so (True part), modify your VAC flag to 1, if not (False part) leave VAC to 0. VAC tells us whether to start with this scope or handle the other scope that referred to this scope. Then use another iif() and test whether VAC is 1. 1 means no recursion yet, we start from VACANCY scope. For True part provide the calculation you already have, the one that refers to the other accounts. For False part provide the calculation* that should occur when you jump from second scope (8008ZZ and 8005ZZ) to this one. In the end of the scope, reset all flags to zero.

In the second scope(s) (8008ZZ and 8005ZZ) use the same logic. First, test for VAC. If zero, it means the calculation starts from second scope, no recursion yet. 1 will be there only if we jumped from the first scope since there we modified VAC to 1 just before the jump. So the first iif() sets other flag(s) (ZZ5 or ZZ8) to 1. Then we test whether ZZ5/ZZ8 is 1. If so, we provide normal calculation, the one that referres to the first scope (VACANCY). If not, we have to provide a calculation* that stops the recursion, just like in the first scope.
In the end of the scope, we reset all flags to zero.

I think you got the picture except maybe for *. Explaination follows. * should be your formula that doesn't refer to other scopes (doesn't create recursion), maybe just an aggregate/rollup of children (see here for an idea: http://www.sqlserveranalysisservices.com/OLAPPapers/Loading%20Aggregate%20Data%20in%20AS2005v2.htm )

Use of Freeze() inside each scope might work too.

All in all, there's no problem in using recursion, you just have to limit it not to be infinitive.

Hope this helps,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

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

thanks for your reply,

will you please elaborate your idea in my script
which i have written in my first post.

Ani

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

I will, but please post your other scope(s), the one for the 8008ZZ (or 8005ZZ) and that involves VACANCY. Also, give some basic info about your parent-child dimension Accts.

I need that to write MDX for recursion.

Regards,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

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

hello

here is my mdxscript; for accounts VACANCY,8005ZZ,8008ZZ

CALCULATE;SCOPE([Measures].[Value]);SCOPE([Accts].[VACANCY]);this=IIf(ISLeaf([Struct-Funds].[ParentEntity].currentmember) OR ISLeaf([Struct-Orgs].[ParentEntity].currentmember),[Accts].[VACANCY],(((([Accts].[8005ZZ],[Measures].[Value])/([Accts].[8005-00],[Measures].[Value]))+(([Accts].[8008ZZ],[Measures].[Value])/([Accts].[8008-00],[Measures].[Value])))+(([Accts].[8018ZZ],[Measures].[Value])/([Accts].[8018-00],[Measures].[Value]))));END SCOPE; END SCOPE;
SCOPE([Accts].[8005ZZ]);this=([Accts].[8005-00]+[Accts].[VACANCY]);End Scope;
SCOPE([Accts].[8008ZZ]);this=([Accts].[8008-00]+[Accts].[VACANCY]);End Scope;

VACANCY account is recursively called in accounts 8005ZZ,8008ZZ

Struct-Funds is EntityStructure Dimension and
Accts is account dimension.

Ani

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

OK, fine, but you haven't said what is the relation of VACANCY, 8005ZZ and 8008ZZ? Are they ancestors/descendants among themselves? What is their position inside Accts dimension?

Regards,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

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

Accounts VACANCY, 8005ZZ and 8008ZZ are independent accounts

CALCULATE;SCOPE([Measures].[Value]);SCOPE([Accts].[VACANCY]);this=IIf(ISLeaf([Struct-Funds].[ParentEntity].currentmember) OR ISLeaf([Struct-Orgs].[ParentEntity].currentmember),[Accts].[VACANCY],(((([Accts].[8005ZZ],[Measures].[Value])/([Accts].[8005-00],[Measures].[Value]))+(([Accts].[8008ZZ],[Measures].[Value])/([Accts].[8008-00],[Measures].[Value])))+(([Accts].[8018ZZ],[Measures].[Value])/([Accts].[8018-00],[Measures].[Value]))));END SCOPE; END SCOPE;

SCOPE([Accts].[8005ZZ]);this=([Accts].[8005-00]+[Accts].[VACANCY]);End Scope;

SCOPE([Accts].[8008ZZ]);this=([Accts].[8008-00]+[Accts].[VACANCY]);End Scope;

Vacancy account is present again recursively in accounts 8005ZZ and 8008ZZ

I am having [Struct-Funds] as one of the Entity dimension
which contains entities and
i am having data (measure values ) for combination of [Struct-Funds] and [Accts]
dimension. i.e
Ex : measure for Entity1 and account 8005ZZ = 5000 etc.

Ani

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

I thought something like this.

          CALCULATE;

CREATE MEMBER CurrentCube.Measures.VAC AS 0;
CREATE MEMBER CurrentCube.Measures.ZZ8 AS 0;
CREATE MEMBER CurrentCube.Measures.ZZ5 AS 0;

SCOPE([Measures].[Value], [Accts].[VACANCY]);
    iif(ZZ5 = 0 AND ZZ8 = 0, VAC = 1, VAC = 0);
    iif(VAC = 1, 
               IIf(  ISLeaf([Struct-Funds].[ParentEntity].currentmember) OR
                     ISLeaf([Struct-Orgs].[ParentEntity].currentmember),
                     [Accts].[VACANCY],
                    ([Accts].[8005ZZ],[Measures].[Value]) /
                    ([Accts].[8005-00],[Measures].[Value]) +
                    ([Accts].[8008ZZ],[Measures].[Value]) /
                    ([Accts].[8008-00],[Measures].[Value]) +
                    ([Accts].[8018ZZ],[Measures].[Value]) /
                    ([Accts].[8018-00],[Measures].[Value])
                  )
            Aggregate([Accts].[VACANCY].Children)
      );
    VAC = 0;
    ZZ8 = 0;
    ZZ5 = 0;
END SCOPE;  
   
  SCOPE([Accts].[8005ZZ]);
    iif(VAC = 0 AND ZZ8 = 0, ZZ5 = 1, ZZ5 = 0);
    iif(ZZ5 = 1, 
        [Accts].[8005-00] + [Accts].[VACANCY],
         Aggregate([Accts].[8005ZZ].Children)
        );
    VAC = 0;
    ZZ8 = 0;
    ZZ5 = 0;
End Scope;  
   
  SCOPE([Accts].[8008ZZ]);
    iif(VAC = 0 AND ZZ5 = 0, ZZ8 = 1, ZZ8 = 0);
    iif(ZZ8 = 1, 
           [Accts].[8008-00]+[Accts].[VACANCY],
         Aggregate([Accts].[8008ZZ].Children)
        );
    VAC = 0;
    ZZ8 = 0;
    ZZ5 = 0;
End Scope;  
   

It might not work, that was just an idea.

But maybe this can be done much more simple if you expain the logic behind. What do you want to achieve with scopes? Tell in words. Maybe there is a way to do it without recursion at all.

Regards,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

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

Thanks Tomislav,

Its really nice tht u gave immediate reply.
I will try your solution and let you know.

but i would like to tell you my complete scenario;

I am having one cube Plan.
I m having 4 dimensions;

i) Account. ii) Entity iii) Scenario. iv) Time

I m having one facttable (Fact) which contains measure values for combination of Entity,Acct,Scenario and Time.
and having dimension tables Entity,Account,scenario,time.
now i am having account 'VACANCY' in my account dimension table.

I m having one Entity table in which entities are present in Parent-Child Hirarchy like;

EntityStruct
     |---Entity1
             |---Entiy2
             |---Entity3
                     |-----Entity4
                     |-----Entity5

i would like to calculate values for the combination of Entity (Entity5),Account (VACANCY),Scenario (A), and year (2009)

value for Account VACANCY is not present in fact table but values for accounts 8005ZZ,8008ZZ,8018ZZ are present
but the actual problem is in accounts 8005ZZ,8008ZZ,8018ZZ because these accounts contain formula
in which vacancy account is called recursively.

i wrote general script in which all other accounts, calculations work correctly but for vacancy account while firing mdx it
gives recursion error.

from the scripts below you will come to know that account VACANY is called recursively.
i wrote belown mdxscript which works fine for all other calculations except for VACANCY

now i would like to calculate value for VACANCY account as per formula and want calculated (rolled up)
value at higher level.i.e,

when i fire mdx for combination of Entity5,Acct VACANCY,Scenario A,Year 2009;it should show value as per formula
but at higher level i.e when i fire mdx for combination of Entity1,Acct VACANCY,Scenario A,Year 2009;it should show
Rolled up Calculated value.

CALCULATE;SCOPE([Measures].[Value]);SCOPE([Accts].[VACANCY]);this=IIf(ISLeaf([Struct-Funds].[ParentEntity].currentmember) OR ISLeaf([Struct-Orgs].[ParentEntity].currentmember),[Accts].[VACANCY],(((([Accts].[8005ZZ],[Measures].[Value])/([Accts].[8005-00],[Measures].[Value]))+(([Accts].[8008ZZ],[Measures].[Value])/([Accts].[8008-00],[Measures].[Value])))+(([Accts].[8018ZZ],[Measures].[Value])/([Accts].[8018-00],[Measures].[Value]))));END SCOPE; END SCOPE;

SCOPE([Accts].[8005ZZ]);this=([Accts].[8005-00]+[Accts].[VACANCY]);End Scope;

SCOPE([Accts].[8008ZZ]);this=([Accts].[8008-00]+[Accts].[VACANCY]);End Scope;

i would like to write script for VACANCY account.

Thanks

Ani

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

Since the value for VACANCY is not present in your fact, we can not refer to it using .DataMember. We can only refer to 8005ZZ and 8008ZZ accounts using that function, to obtain their values. Do any of these have children below them? I suppose VACANCY doesn't. How about the other two?

I just want to check with you how come 8005ZZ have values in fact, but you also scope them?

And the most important one - how do you see these scopes should fire? In what order? You haven't described that much, you just said "as per formula" but that is what I want to hear in words - a story on how to calculate them in sequence. Then I can modify the scope or formula. I need to understand that in another way (words, ...) because formula just tells me it's a loop. Where does it start from?

I think you should first calculate 8005ZZ and 8008ZZ, not using VACANCY, but using a version of formula for vacancy that is modified not to loop infinitelly. Then we could use the forumula for Vacancy as is.

So, can we somehow modify definitions for 8005ZZ and 8008ZZ and in what way (you understand it better)? Maybe by replacing vacancy in them with definition for vacancy, but definition that is modified not to refer back to 8005ZZ and 8008ZZ - instead, it should refer to children of them, datamember, or something of a kind. That would prevent the loop.

Regards,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

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

Some problems with Windows Sidebar in Windows 7 Beta

I found some problems with Windows Sidebar in the public beta. After Windows 7 installation it is impossible to start under rights for the administrator of him. What we have to do Windows 7 gadget will have to run in the sidebar area, which is and bar that can be located on the side of the desktop.
1. Close all gadgets on desktop.
2. Take ownership and grant full control permissions for Administrators user group of the following files located in C:\program Files\windows Sidebar folder: settings.ini sidebar.exe And inside the en-us Folder: sbdrop.dll.mui Sidebar.exe.mui
3. Rename to backup the 4 files listed above.
4. Download Win7-Sidebar-Fix.zip.
5. Extract and copy the contents of the ZIP file to their corresponding folders in C:\Program Files\Windows Sidebar folder, overwrite and replace existing files if applicable.
Reload Windows Sidebar

Given up installing.., any suggestions?

If anyone has any suggestions after reading?

Installed maybe 20+ times already, both 32 and 64 bits versions.

Things verified:
1. DVD's are OK, checked several checksum reports
2. Install from Win XP with install from HDD
3. Installed on raid with device drivers, without.
4. Installed on separate HDD, always new partition, sometimes pre-formatted, sometimes formatted by install program
5. Installed without any USB devices connected
6. Installed from several DVD drives
7. Burned to several DVD's, +r and +rw.
8. Installed for first or second primary partition on HD

Environment:
MSI P6N Diamond motherboard, 4x1GB memory, several harddisks, MSI 8800GTS

Results:
- 1 time x64 installed all the way but finally gave up after installing Nvidia WDDM drive through windows update, this driver re-started every two seconds (was the best install in retrospect, it even recognized the multiple monitors)
- Many installs failing while expanding files (0%, 11%, 35%, 88%)
- Some installs on the raid array (2 times 500 GB Hitachi Mirrored) ended with an array deleted by the install, rebuild necessary
- Some installs ended where the Windows XP partition did not boot anymore, fixboot necessary to boot again. With these installs the 'removed failed installation' boot option was active, so Windows 7 de-installed itself, resulting in invalid boot record.
- Some installs left data on the partiiton. One time the files were all invalid with a checkdisk almost all files were lost. That is why I tried formatting from the instal, but no....
- Others left files like Report.wer with content as this:
E v e n t T y p e = P n P D e v i c e P r o b l e m C o d e ♪
E v e n t T i m e = 1 2 8 7 6 3 8 7 6 0 8 6 1 0 4 0 0 0 ♪
C o n s e n t = 1 ♪
U p l o a d T i m e = 1 2 8 7 6 3 8 7 6 0 8 7 3 5 2 0 0 0 ♪
R e p o r t I d e n t i f i e r = 6 3 9 1 5 8 c 0 - e 2 0 3 - 1 1 d d - 9 6 6 5 - b 3 5 3 b a 8 0 6 5 0 7 ♪
R e s p o n s e . t y p e = 4 ♪
S i g [ 0 ] . N a m e = A r c h i t e c t u r e ♪
S i g [ 0 ] . V a l u e = x 8 6 ♪
S i g [ 1 ] . N a m e = H a r d w a r e   I d ♪
S i g [ 1 ] . V a l u e = U S B \ V I D _ 0 3 F 0 & P I D _ C 2 0 2 & R E V _ 0 1 0 0 & M I _ 0 2 ♪
S i g [ 2 ] . N a m e = S e t u p   c l a s s   G U I D ♪
S i g [ 2 ] . V a l u e = { 3 6 f c 9 e 6 0 - c 4 6 5 - 1 1 c f - 8 0 5 6 - 4 4 4 5 5 3 5 4 0 0 0 0 } ♪
S i g [ 3 ] . N a m e = P n P   p r o b l e m   c o d e ♪
S i g [ 3 ] . V a l u e = 0 0 0 0 0 0 0 A ♪
S i g [ 4 ] . N a m e = D r i v e r   n a m e ♪
S i g [ 4 ] . V a l u e = U S B S T O R . S Y S ♪
S i g [ 5 ] . N a m e = D r i v e r   v e r s i o n ♪
S i g [ 5 ] . V a l u e = 6 . 1 . 7 0 0 0 . 0 ♪
S i g [ 6 ] . N a m e = D r i v e r   d a t e ♪
S i g [ 6 ] . V a l u e = 1 2 - 1 3 - 2 0 0 8 ♪
D y n a m i c S i g [ 1 ] . N a m e = O S   V e r s i o n ♪
D y n a m i c S i g [ 1 ] . V a l u e = 6 . 1 . 7 0 0 0 . 2 . 0 . 0 . 2 5 6 . 1 ♪
D y n a m i c S i g [ 2 ] . N a m e = L o c a l e   I D ♪
D y n a m i c S i g [ 2 ] . V a l u e = 1 0 3 3 ♪
F r i e n d l y E v e n t N a m e = C o u l d   n o t   l o a d   d r i v e r   s o f t w a r e ♪
C o n s e n t K e y = P n P D e v i c e P r o b l e m C o d e ♪
A p p N a m e = U S B   M a s s   S t o r a g e   D e v i c e ♪
A p p P a t h = X : \ $ W I N D O W S . ~ B T \ W i n d o w s \ S y s t e m 3 2 \ d r v i n s t . e x e ♪
R e p o r t D e s c r i p t i o n = W i n d o w s   w a s   a b l e   t o   s u c c e s s f u l l y   i n s t a l l   d e v i c e   d r i v e r   s o f t w a r e ,   b u t   t h e   d r i v e r   s o f t w a r e   e n c o u n
t e r e d   a   p r o b l e m   w h e n   i t   t r i e d   t o   r u n .   T h e   p r o b l e m   c o d e   i s   1 0 . ♪

- Others failed with no reports in this directory: \ProgramData\Microsoft\Windows\WER\ReportQueue\
- Sometimes target partition was empty after failed install, sometimes it left 1,6GB of programs/config, an x64 install came to 88%, leaving 7.4 GB.

Maybe I should just test with the Virtual PC environment, that installs fine :-(. I never had these problems when beta testing XP..........

Changed type Mark L. Ferguson Wednesday, February 18, 2009 4:09 PM

deprecated

Changed type Sigourney_Weaver Saturday, February 27, 2010 7:39 PM
Edited by Sigourney_Weaver Sunday, March 7, 2010 4:31 PM

Reply:

Hi,
I am not sure whether this article answer your question:
http://msdn.microsoft.com/en-us/library/ms137952(SQL.90).aspx

Regards

Ryszard Gawron MSFT

This posting is provided "AS IS" with no warranties, and confers no rights.

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

Compiling doesn't do anything, besides coping the dtsx to the bin folder, but if you want you can create a Deployment Utility when compiling. (right-click project->properties)

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

not too sure about the compiling part but clicking the debugging button (the play button) starts to compile and run the package and includes a list of errors and/or warnings and step by step process check list.

im not sure if that helps.

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

does your Computer Heat up faster

I have and AMD Turion 64-bit X2, nVidia chipset graphics (integrated), and using Windows 7 32-bit on a Laptop.

On the OS you can choose Power options, Balanced, Power Saver, or High Performance. I always use Power Saver because my computer runs best on that setting, since my graphics chipset overheats (REALLY fast) then make everything go slow. And using the nVidia control panel I set it for the highest Performance options)

I use my laptop to play games 70% of the time (simple MMOs, no hardcore stuff). On vista my computer runs at 140-170 degrees (F) with the Power Saver option, and on the Windows 7 I have, Average temperature so far goes from 160-200+ (when im playing my games).

I'm sure my fan could "breath" good because it runs fine on Vista. Is there anything that could be making the temperature go through the roof?

Reply:

I've had issues with the latest Beta nVidia drivers (from Windows Update) on my Dell laptop -- exactly as you describe, the graphics chipset heats up quickly. You could try rolling back the video driver to a previous version (the one that originally installed with Win7 Beta worked pretty well) or you could switch to nVidia's shipping driver for Vista.

Wolf Logan, MSFT

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

im sure my processor is overheating. its a single core amd 2.4 ghz processor thats about 3 years old. i have 2gb ddr2 ram at 800 mhz and a radeon x1300 graphics card. my pc seems to just "stop" so to speak. i cant press anything or nothing. ive my graphics card over heat beofre and the screen started to shake within itself but everytime W7 freezes, it shows the processor speed as 100% so im sure its overheating

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

My Turion-based system seemed to be getting hotter, and the fan was running constantly.
Here's what fixed mine: check the advanced power settings. There is a section for minimum CPU speed, both plugged in and on battery. Mine was set to a minimum CPU speed of 100% when plugged in, so there was no "throttling" or underclocking being done - that's the point of the Turion line. I knocked that back to 25% and it's been smooth sailing ever since.

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

thanks! my pcs running better at the moment. have to wait to see if it hangs though which is annoying but thanks all the same!

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

pc was still working when i left at 12 UK time. switched it on at 8.30. seems to work ok! thanks very much!!!!

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

Please let us decide where to place USERS directories!

Hi everybody!
this, for me, it's a problem that exist from win95 till today.

Well windows default users directories are so damn cool. you can access them by start menu and in win7 also by library icon pinned to the superbar. nice! but why i can't decide where put them nor "make default" (in a easy and simplified way.. not needed to edit the registry) what those directories are?

here are a list of problem (imho) derivated from this issue.
1) when using two or more partition: tipically the OS partition is very small respect the data/user partition. so if we put USERS directories inside the OS partition by default, we can't use them: how many albums/films/downloads/10MP photo you can store on a 10-20-30GB partition? not so much eh? and everytime you put there a big film or install a program you reduce vital free space to your OS (consider the recycler bin as example, not mentioning swapping areas for who doesn't have 4GB of RAM).
2) i personally use and spread, on every computer i repair, the partitions separation: one for OS and programs which needs to be installed to work and the other for programs which doesn't need installation and user data. so when a format or serious errors occur you just need to format the first partition and all your data is safe on the other.
3) a fact that happend to me. when i was reinstalling windows xp on my machine i got old USERS directories all locked up for an unknow reason by the new OS installation.. there was no way to get their content and i lost all my documents.

well maybe, considering the second point, the USERS directory that needs to be moved (for the pleasure of the user) are just the directories that contains users' generated file, like images, documents, video, music, savegames :P, downloads etc. and not temporary files or apps stored preference.

i'd like to know what other people think about this question :) thank you and sorry for my english :)

Moved by Othorvath Friday, January 16, 2009 11:34 PM (Moved from Windows 7 Installation, Setup, and Deployment to Windows 7 Miscellaneous)

Reply:

As someone who supports hundreds of Windows users, it's a complete pain in the ____ to have the faff of _trying_ to keep their data away from system files. Once you've loaded up a client install with 400 third-party applications, there isn't a tool alive which can extricate your priceless data from the replaceable system files.

There's an argument that many user files _are_ system files, but hey, that's no excuse.

The powers of kung fu never fail!

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

You can do this via an automated installation of Windows and using the FolderLocation value in unattend.xml: http://support.microsoft.com/kb/949977. Not quite simple as you've asked, but it is possible.

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

Mozy Pro Client - Backup

Is anybody able to get the Mozy Pro backup client to work on windows 7? Specifically, I want the backup set to show up as folders in windows explorer.

Will D. Robinson

Changed type Ronnie VernonMVP Saturday, February 7, 2009 12:13 AM

MouseOver a taskbar item

Sometimes a program gets a disadvantageous color assigned and when I hover mit the mouse it's hard to read. Here a screenshot: http://img249.imageshack.us/img249/8565/unbenanntna9.jpg

Reply:

Hi

Yes noticed this more so when certain wallpaper colours are used as this new taskbar option is to give you on some functions like copying files a progress bar, if you have not already I would file it via Feedback as a GUI issue.

There cannot be a crisis today....my schedule is already full

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

No - right now I didn't.

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

it's called Color Hottrack, where the overlay you get from your mouse pointer is generated based on the most dominant colour of the icon on the button. so Firefox's hottrack would be orange and Control Panel would be blue.

i don't think you can disable that.

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

performance

running 7 on a four years old custom built pc with a measly 512MB of DDR Ram, 1.67GHz AMD Athlon XP processor and 128MB Nvidia 6200LE Graphics Card - installed drivers for audio and graphics from windows update. installed XP driver from manufacturer for network adapter (SiS 900) and installed existing usb wireless adapter driver from disk. audio, video and internet all working fine.

Reply:

And how's your perceived performance compared to XP? I could imagine that you'll get a lot of pagefile swapping (=hard disk activity) in real-world usage scenarios since the OS alone takes up your entire physical RAM.

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

actually my ram isn't being taken up by the os alone, as it wasn't with vista on this computer: simple tasks and processes are executing fine - aero, media players, streaming internet, open office, explorer, defender, file transfer to and from disk, defragmenter, clean up etc etc - all the real world day day to day tasks i'd normally use this pc for work smoothly without freezing or hanging. obviously it's not anywhere near as fast as with xp pro but as with vista on this pc i really don't mind.

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

I've got similar specs on my HP laptop(with 1gig of ram). Performance "feels" better than XP, and certainly faster than Vista(I split the drive and have both installed). I even went as far as using Easy Transfer Wizard and copied my "profile" to the Win7 side. Have to admit it really seems quite nice. Runs quickly, and the only "crashes" thus far have been Firefox! I do note more pagefile swapping, but doesnt seem to have an effect on performance.

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

User-interface issues

After using Windows 7 today as my main OS for work I would just like to share my issues:

Multiple lockups of the UI doing various operations including:
-Downloads from IE 8 while the file is copying from the temp folder to the download location
-Large file copy of files such as MP3s (90GB+)
-Randomnly browsing through the file system of the local hard drive
-Using the HP Product Bulletin update feature
-Installing the HP Product bulletin software (first time)

When these occur I can continue to use the OS however I can't restart or shut down the laptop cleanly. It requires a hard power down via the power button.

Also the VisionApp remote desktop 2008 SP1 installs properly but as soon as you connect to a server it gives a memory error.

Other than that, it's a beautiful OS and I can't wait for MS to finish it.

Reply:

It would be helpful to others if you posted some details about the specs of your system and whether this was an upgrade or clean install. :)

I've not had these issues on my install, but I'm running pretty high-end equipment.

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

Sure no problem. This was a clean install on the laptop below. Windows 7 Ultimate x86. I am using the Windows-supplied drivers for everything except I loaded the latest ATI drivers. My laptop isn't the greatest but it's run Vista since beta without many performance issues. I must say like a lot of people have that Windows 7 does seem a lot peppier than my Vista sp2 (beta) installation.

HP nx9420
T2400 Core Duo
3GB of ram
ATI x1600
250GB 7200RPM sata drive

The problems above are minor IMO for beta 1 of an OS. All in all I had to hard reboot my notebook 4 times in 9 hours of work today. It wasn't as though I could not continue to use it, it was just annoying that I couldn't kill the hung processes even via task manager. If you have any ideas let me know. I'm actively sending reports to MS so hopefully they will be resolved in the next few builds.

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

i've experienced the browsing problem but i thought it was because my external hdd went idle.
now i'm thinking differently.

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

Biggest problem I have found yet

internet explorer, if you DONT change the taskbar, when I download stuff, the download window pops up, BUT its not coming up infront of everything, so I dont know that it worked other than the icon turns orange. I like having all the buttons combined. anyone else have this problem?

Reply:

this issue seems tab specific, where if you don't have that tab active it doesn't show up in front until you switch to that tab. this seems to be an IE issue.

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

MCE Minimize

Playing LiveTV/Watching Video

On minimizing MCE in Windows Se7en Beta x64 a 'snapshot' is taken for the task bar thumbnail and the thumbnail is not 'live' as I would expect. The thumbnail in WMP is 'live' and works as I would expect. If the window in MCE is resized then the thumbnail is 'live'.

Ms Support forum

Monday, March 28, 2022