After installing SSRS! You can’t manage Reports site

March 31, 2010

It’s just a quick tip after you’ve successfully installed SQL Server Reporting Services on Windows Vista or Windows 7, you go to http://{Server-Name}/reports which redirects you to http://{Server-Name}/reports/Pages/Folder.aspx you find out that you can’t control anything and the site looks like this

Don’t worry what you should do is to, right click on Internet Explorer or your favorite browser then run as administrator and retype your SSRS Reports site URL http://{Server-Name}/reports you’ll find you can manage everything as you see

To not open your browser as administrator everytime you manage your Reports you should add your current user as Content Manager or as you wish. From Properties-> New Role Assignment -> Type the username of current user -> Select role -> OK

Open it without run as administrator it will look like as you want.

Advertisements

10 to 11

March 5, 2010

Excuse me, this post not related to BI which my blog talks about!

UPDATE (Sunday, Mar 7, 2010 at 2:39 am)
1- NOW 10 to 11 supports numbers with country code format +20 and 0020
2- NOW 10 to 11 supports migrating numbers with any known format.

After the decision of The Egyptian Agency for Telecommunications to change cell phone numbers 11 numbers instead of 10 http://www.masrawy.com/News/Egypt/Politics/2010/march/4/mobinil_vodafon_etisalat.aspx , I found it too tough to change your contacts number manually so I’ve developed this application to do that for you. 

Simply my application 10 to 11 (thank you my mother, she suggested this name) iterates all outlook contacts not SIM contacts and modify the mobile phone number of your contacts to the new format\schema which The Egyptian Agency for Telecommunication announced earlier. 

Download it http://cid-3e2288e7a8e55f56.skydrive.live.com/self.aspx/Public%20folder/10%20to%2011%20setup.zip

Vodafone
010 => 0100
016 => 0106
019 => 0109 

Mobinil
012 => 0122
017 => 0127
018 => 0128 

Etisalat
011 => 0111
014 => 0114 

And you can choose what to change to the new format….
 

I prefer to backup you contacts by using this program PPCPimBackup get it from http://tinyurl.com/l8wh5a

I’ve windows 6.1; I tried it and it works like champ 🙂

Download it http://cid-3e2288e7a8e55f56.skydrive.live.com/self.aspx/Public%20folder/10%20to%2011%20setup.zip


Business Intelligence Keywords

March 4, 2010

I mainly write this post for novices who need to begin with Business Intelligence and to be aware of the most Business Intelligence keywords thus they could read any Business Intelligence article without any problem.

Business Intelligence: The art of extracting right information in timely manner to right person from raw data, it doesn’t depend on specific technology but very wide of technologies depend on; like Data Mining. It makes the organization realize its resources, potential and give the Big Image* to the status of its goals.

Operational Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting but they don’t care about KPIs and Measures more than data listing.

Tactical Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting beside they give a wide solutions to tactical managers who can use them to get the most of KPIs (Profit in dollars, number of CRM tickets, etc) to take their organization step towards its goals.

Strategic Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting it helps the top management get the status -very brief status- of the organizations and its step towards its goals.

Measure\Fact: What’s the organization looks for, profit in currency, revenue, number of user come to website, number of CRM tickets, etc…

Dimension: How the Measure\Fact measured per, means profit in currency (Measure\Fact) can be measured per time, sales region, sales person, product type, etc.. so we call time, sales region, sales person, product type dimensions. Simply everything you can group by…

Hierarchy dimension: Dimension has self-relationship like time dimension we may see Year, Quarter, Month, Week, Day and may be more deep details. Simply everything with more than one level (deparment employee).

Read the rest of this entry »