Business Viewpoint Client Dimension is "Loading..."

Cognos 8 Business Intelligence Business Viewpoint
1

and keeps saying loading…??

i installed and configured Business Viewpoint with a SQL database. After opening the Client and succesfully creating a new dimension i tried to expand the dimension it just says “Loading…” ? and nothing happens

what is wrong??

2

hi,

this is probably caused by the SQL Server Database, being installed as a case sensitive database.

execute the following steps:

Open SQL Server Management Studio
Select and expand the Business View Database
Expand Programmability > Functions > Scalar-valued Function
Right click on dbo.GET_OBJECT_PROPERTY and select "Modify"
Scroll to the bottom of the function and modify the the following from:

CLOSE PROPERTY_C
DEALLOCATE PROPERTY_C

to

CLOSE property_c
DEALLOCATE property_c

Execute this function to save it.
Now you shouls see the newly created dimensions in Business Viewpoint Client.