I am trying wrap my head around how data is being served to Project Server. I am trying match up a value (actual cost) to project lines in an Executive View of Project Center which displays each project. This actual cost comes from another database; the accounting database. I am assuming I have to build it in an OLAP Cube. Anyways, I...
Hi I'm trying to enforce windows authentication for users of a .Net application on Web Server to access a cube on a Microsoft Analysis Services database on SSAS and just going nuts trying to get it to work! I am using <identity impersonate="true" /> in the web.config. Anonymous access is turned off in IIS and Integrated Windows Authen...
I have an important problem running ETL Process in production environment. While my ETL is running, the OLAP Server turns extremely slowly, I think this is because the ETL is updating several existing rows in the fact table and adding new ones. I tried to avoid this problem having a whole data base replication and ETL writes in DB1 and O...
I'm developing a data warehouse and have come up against a problem I'm not sure how to fix. The current schema is defined below: DimInstructor <- Dimension table for instructors DimStudent <- Dimension table for students I want to implement a scenario whereby if details of an instructor change in my OLTP database, I want to add a new r...
I'm developing my university graduation project and I'd like to include an OLAP-based reporting module. In the past, I've used Mondrian with JPivot as an OLAP solution for Java projects and I'm looking for something similar using .NET. The tricky part is that my project should run on Mono and MySQL (installation environment is a Linux ...
My fact table has a "Date" column that I have used as a foreign key to the Time Dimension table I used SSAS to create for me in the datasource. However when I deploy the cube and browse it, adding the time dimension attributes or any of its hierarchies do not filter anything on the measures. Its like there is a disconnect between the tim...
I am new to OLAP, Dundas. Is there any sites to learn easily and quickly? anywhere can I see the source code, like how the controls are talking to db and how the dundas charting controls are customized in code behind? ...
Hi all, I've got two questions about the Oracle Analytic Workspace Manager (10.2): 1. Cube does not show floating point values: We have a custom, non-materialized view with average rating values saved as decimal/float type. After creating our cube with aggregation rule 'Average' and cube type 'Decimal' the resulting output seems to cut...
http://en.wikipedia.org/wiki/Online_Analytical_Processing How is this two related? How to know that we are dealing with this type of programme? ...
I need a mental process to design an OLAP database... Essentially for standard relational it'd be (loosely) Identify Entities Identify Relationships Identify Properties of Entities For each property ensure property can be related to only one entity ensure property is directly related to entity For OLAP databases, I understand the...
Hello gurus, I would like to know if i can get a case study for my dissertation with the above topic. I am in dire need of data I can use for the developing the data warehouse and that would help me arrive at a possible conclusion of using the BI application I would be developing.Many thanks for your audience. Regards, Tunde ...
I am programmatically defining an OLAP cube (SQL Server Analysis Services) which imports measure groups and dimensions from two other cubes. How can I connect a dimension from one cube to a measure from another cube? ...
I'm working for a company running a software product based on a MS SQL database server, and through the years I have developed 20-30 quite advanced reports in PHP, taking data directly from the database. This has been very successful, and people are happy with it. But it has some drawbacks: For new changes, it can be quite development...
Hi all, I am new to Business Intelligence. I just got hired by a company in order to complete their websolution, implementing a BI Module. After lot of reading, I think I could get an idea of what a BI Process looks like, you'll find enclose my idea of a BI process. Can you please tell me if this is a correct vision of the all workflo...
Hi all, I was wondering what Palo OLAP Server handles as input Database ? Does someone know where I can find a list of the input Database supported ? Thank you ! ...
I would like to know which are the best OLAP tools in the market today and how i can run it in my own business. Also, is there any free OLAP tool out there? ...
I'm wondering if there is any desktop OLAP solution that can use SQL Express (and therefore does not require Analysis Services) I've been tasked with finding a way to allow our customers to do 'Ad-Hoc' reports, but the vast majority of them are on Sql Express, In previous jobs, customers have had Analysis Services and typically Cognos o...
Hi, I have downloaded the 30-day trial of DWExplorer, and I also got 2 examples files, Financial Overview.dwew and Product Overview.dwew. But whenever I open one of those 2 files, I get the following error message: 1: An error occurred while connecting to the server: -> [SourceException] -> Type [SourceErrorType]: ConnectionLost -> Sou...
I have the following star schema: Objects <-> Facts <-> Simulation -ObjectID -ObjectID -SimulationID -SimulationID -SimulationID -ObjHierarchy -Volume -ObjectType Now I'm trying to filter the cube using both dimensions: select [Measures].[Volume] on columns, [Objects].[ObjHierarchy].[Level 0...
Normally you can add a query as a new data source in Cognos PowerPlay (I'm running PowerPlay version 7.3), but when I try to do so I cannot select any queries from my Access database. The dropdown menu which normally shows the existing queries in the database is empty. When I add a table as a new data source it works fine, and all the ta...