I'm creating a data analysis tool which has large tables and lots of data.
It's going to need pivottable and drilldown functionality.
The only tools I have available are Office 97 and Visual ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10937181.html
Zones:
MS AccessDate Answered: 08/09/2000 Grade: A Views: 0
In 2005, my company is looking to make some improvements in report delivery. We've started messing with OLAP cubes in MS SQL Server 2000, and so far they're working out great.
However, I'm stuc...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21255674.html
Hi,
I look for a solution to localize an OLAP cube dimensions
For example if you have a dimension product with levels Car, Bicycle
is it possible to get from the cube localized dimension na...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21425324.html
Zones:
Databases,
OLAPDate Answered: 05/16/2005 Grade: A Views: 0
Dear expert,
I have need a way to change the connection of a lot of Olap pivottables to another Olap cube.
Olap pivottable doesnt have a SourceData property.
Is there a way to do it, preferably ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/30/2007 Grade: A Views: 0
Hi, (OLAP Newbie)
I have data on several metrics. Each metric has a value that varies by region and date.
I have made a cube with 3 dims
1) Metric Name
2) Region Higherachy
3) Time
Should...
http://www.experts-exchange.com/Database/OLAP/Q_23394225.html
Zones:
OLAPDate Answered: 05/12/2008 Grade: A Views: 27
Hi I have created a OLAP Cube in which i have fact table
1. Gross Profit
EventID
TypeID
RevenueDate
GrossProfit
and a measure as count of User which comes from the Dimension UserInfo...
http://www.experts-exchange.com/Database/OLAP/Q_23562139.html
I have a cube with a Project and an Offer dimension. There is a one to many relationship from projects to offers. The client's reporting application is excel and it appears that you can only have...
http://www.experts-exchange.com/Database/OLAP/Q_23835031.html
Zones:
OLAPDate Answered: 11/10/2008 Grade: A Views: 24
Hi. i have an OLAP based pivot table coming from the DB. our DBA created KPI traffic light, and i want to know how can i use it to show results in the excel sheets / charts.
does anyone know ho...
http://www.experts-exchange.com/Database/OLAP/Q_23063125.html
i'm running OLAP cubes in analysis services via a browser.
when i make proccess / Deploy - i get this Error message.:
Error HRESULT E_FAIL has been returned from a call to a COM component.
...
http://www.experts-exchange.com/Database/OLAP/Q_23177307.html
Experts,
i have to select an olap tool for information analisys, i have 5 options:
BussinessObjects, Pilot, Sygate, Comshare and Oracle Express.
Is there any documentation about the
evaluati...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10294222.html
Zones:
DatabasesDate Answered: 03/01/2000 Grade: B Views: 0
