Feeds:
Posts
Comments

Archive for February, 2013

I have a scorecard and I want to link an item in scorecard to a grid report. When an item in the scorecard is selected, the grid report will only display the children of the item selected.

For example,

When the following cell for Clothing CY2008 as highlighted on the screenshot below gets selected, the grid report on the right hand side will display the breakdown of the Clothing product category by product subcategory for CY2008.

Capture

As you see from the above screenshot, my dashboard contains 1 header and 2 columns.

The header is divided into two zones i.e. top row and Zone 1. The top row header is linked to the Product Categories filter and the Zone 1 header is linked to the Calendar Year filter.

The columns have 2 zones i.e. Bottom Row and Zone 2. The Bottom Row contains the Sales by Product scorecard whereas the Zone 2 contains the Sales by Product and Year grid report.

Capture2

To link an item on the scorecard to a grid report:

1. Edit the dashboard

2. Locate the grid report

3. Hover over the down arrow on the right.

Capture3

4. Choose “Create Connection” menu. A Connection menu will pop up.

5. Map the Items to get the value from the Bottom Row – (1) Sales by Product as per screenshot below,.

Capture4

6. Select the Values tab. Map its values to ProductCategories from the Member Row: Member Unique Name as per screenshot below.

Capture5

7. Repeat Step 4 to Step 6 for the CalendarYear mapping.

Capture6

Capture7

8. Save the dashboard then deploy it.

 

Read Full Post »

The answer to that is below (THIS SOLUTION DOES NOT WORK IF YOUR VM IS ON A DRIVE WITH LESS THAN 100GB FREE SPACE!!!. NOTICE THAT THE VIRTUAL DISK BECOMES 100 GB BUT THE ACTUAL DISK SIZE REMAINS AT 40GB. CREATE THE VM FROM SCRATCH IF THAT IS THE CASE). REFERENCES – http://www.ehow.com/how_12146670_increase-virtualbox-hard-drive-size.html

 

1. Take a snapshot of your VM then back it up. Then shutdown your VM.

2. Exit from Oracle VirtualBox VM

3. Run command line on your local machine

4. Locate the vboxmanage.exe file on your local machine

5. Type in the following command to retrieve a list of the hdds.

vboxmanage list hdds

Sample Output:

C:\Program Files\Oracle\VirtualBox>vboxmanage list hdds
UUID: c0635a28-d5b1-416e-8d34-c1a6091d82e9
Parent UUID: base
Format: VHD
Location: D:\WIN2K8ENT-Vanilla\Virtual Hard Disks\WIN2K8ENT.vhd
State: created
Type: normal
Usage: Chins VM (UUID: 4f309303-90cd-4159-ad1a-556cbcf7aabb) [Snapshot 1 (
UUID: 48e72208-0a0f-4182-bfe1-195f49956679)]

6. Mark and copy the UUID number

7. Type in the following command to resize the hdd to 100GB

vboxmanage modifyhd c0635a28-d5b1-416e-8d34-c1a6091d82e9 –resize 102400

Sample Output:

C:\Program Files\Oracle\VirtualBox>vboxmanage modifyhd c0635a28-d5b1-416e-8d34-c1a6091d82e9 –resize 102400

0%…10%…20%…30%…40%…50%…60%…70%…80%…90%…100%

8.  Check the VM Machine Settings and note that the hard disk space is now 100GB. Run the VM to test.

Read Full Post »

Recently, I built a VM that has got SQL Server 2012 Developer edition and SharePoint 2010 Server Enterprise edition in it. However, I have forgotten to rename the VM before the installation. So I thought, should be alright as it is just a server rename. Boom! SharePoint failed to work. SQL Server name has not been updated!

 

First attempt to recover SharePoint:

1. Uninstall SharePoint 2010 Server . Go to Control Panel > Uninstall programs > SharePoint 2010 Server

2. Install SharePoint 2010 Server from the media.

3. Run the SharePoint Configuration Tool. This step failed.

4. Run SharePoint 2010 Central Administration. Failed to load.

5. Restart the VM. SharePoint still failed to load.

I thought, gosh, do I really need to build this VM from scratch ??!!  I already spent one day building it.

 

Second atttemp to recover SharePoint:

So I decided to try again.. this time I checked if the SharePoint created databases or sites in the IIS.

1. Uninstall SharePoint 2010 Server . Go to Control Panel > Uninstall programs > SharePoint 2010 Server

2. Check SQL Server 2012 database to see if there are any SharePoint related databases created. If there are, delete all of them. In my case, there is none.

3. Open IIS. There are 2 sites created by SharePoint.  My IIS pretty much has Default website installed with no custom sites. Do not delete this default website. Delete all SharePoint sites.

4. Install SharePoint 2010 Server from the media. When prompted to overwrite the existing SharePoint sites, choose Yes.

5. SharePoint works successfully 🙂

 

To rename SQL Server 2012, follow the steps in the following link:

http://msdn.microsoft.com/en-us/library/ms143799(v=sql.105).aspx

In my case, it is a stand-alone server, so the steps are below:

For a renamed computer that hosts a default instance of SQL Server, run the following procedures:

sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO

Read Full Post »

%d bloggers like this: