Hi guys, I have been charged with the task of analysing the log table of my company's website. This table contains a user's click path throughout the website for a given session. My company is looking to understand/spot trends based on the 'click paths' of our users. In doing so, identify groups of users that take on a certain 'click pa...
I am trying to work out through the sample code that comes with Fast Track to MDX. ...
Asked this first on serverfault, and someone recommended that I ask here. I'm looking for advice from anyone out there who has experience integrating SharePoint with a business intelligence application like Cognos. Our BI team wants to be able to report on data stored in SharePoint. Their tool of choice is Cognos. What's the best way t...
I'm a relative newcomer to SAP, so please pardon my ignorance. I'm looking to use Java to work with an SAP BI Cube (select, insert, update, delete type of work). At this point, I'm planning on using JCo to execute the appropriate function modules, but I don't know which function modules to use or how to use them. Does anyone have any ex...
I have a number of reports deployed to a SQL Server 2005 Reporting Services server. They were all developed using the same Report Model (SDML) that references the same Data Source View (DSV) that points to a test database filled with mostly dummy data. Now, I would like to make those reports pull data from the live database with our real...
Please check out the following query. The SQL isn't as bad as it looks. Basically, we have a fact table and some simple joins to some dimension tables. Then we have a join to a derived table, given the alias ACCOUNTS-DIM-DEP SELECT dw_mgr.fa_trans_fct.period, dw_mgr.fa_trans_fct.asset_cost_company_code, dw_mgr.fa_tra...
I'm trying to program some user-behavior-monitoring functionality and it's a bit tricky. For example how do you go about recording a user's clicking path to be used in future analysis? Am I trying to reinvent the wheel? is it easy? is it harder than what I'm thinking? ...
Hello, I have been thinking about the correct approach to face our clients and talk about a Business Intelligence project. I would like to receive your opinion about how to make that approach. Do you have some advices, papers or case studies I should follow? Thanks in advance, Ricardo :) ...
We have a number of Actions defined in a BDC (Business Data Catalog) definition in SharePoint, and need to change the order they are displayed in the UI. Within the Action defintion, there is a Position field, which we are specifying, however, the UI wants to display everything in Alphabetical order, which isn't what we are after. An e...
Hi, I'm in a position of evaluating products / approaches to build Business Intelligence Dashboards on top of Sharepoint WSS (no MOSS at this stage). Does anyone have any suggestions where would be a good place to start? The BI platform is currently built on SQL Server 2005 / SSIS / SSRS and we're currently investigating adding SSAS to...
Does anyone have resources that give a list of things to consider when designing a ROLAP cube, as opposed to MOLAP (I'm doing it in Pentaho, but I guess the principles are not dis-similar for other implementations). For example, I'm thinking of things like: should extra transformational work be done at the ETL stage to reduce computati...
Hi all, Background: We need to consolidate sales data across the country to do analysis Our Internet connection/IT expertise/IT investment is not quite strong, therefore full BI solution is out of question I tried several SaaS BI solution (GoodData, ZohoReports) and while they're good, they seem not to fully support what we need We'r...
hi, I use the oracle BI administration tool and I want to change the schema I select data from. My idea was that the user will pass a parameter in url (I use the go url option) and according to that parameter I will know which schema I need to switch. I created two initalization blocks. select the name of the schema by the given par...
I'm feeling like a bit of a moron, but I can't find how to install Business Intelligence Development Studio 2008. I have 2005 currently, but need to upgrade for some features. I'm pretty sure that it's included with SQL Server 2008 Standard, but I guess I could be wrong. Is it included? and if so, where do I find the install for it? ...
Hi Guys I have a SQL Server 2005 data-mart star schema with the usual fact and dimensions tables. This is deployed and being populated via an SSIS based ETL package. All fine so far. I have just been approached by the customer with a new requirement. Never, I hear you say! This requirement will mean I need to add a new dimension table ...
I will start a reporting tool for some local ERPs about sales, invoices, orders, customers, inventory, etc. I wonder if exist a sample schema appropriated for this case (in star or snowflake form) so I can have a solid foundation. I have understanding about basic BI desing, but taking in account this is a common problem, I wonder if ex...
I'm new to the Hyperion Workspace world, so hopefully there's an obvious answer to this question. Basically, I want to be able to add a simple URL link to one of the folders within a Hyperion Workspace (v 9.3.1). I've found information on SmartCuts, which appear to be local links to reports which are served up by the Hyperion server;...
I have an analysis services cube in SQL server 2005 which I'm connecting to via an excel front end. When I connect via one user its fine, but when I log on to the same machine as another user I get an error in my excel spreadhseet - "user...does not have access to the [Cube name] database" Obviously the first user has the correct permi...
Hi, I've spent 4-5 hours or so in various forumns and at their websites researching reporting tools that can aid me in my development. I'm new to using tools like this and could use a bit of specific guidance. I'm working on an web app that will be hosted on one server, but accessed by multiple users through login. Each user will ha...
Is it possible to run an SSIS package created by SQL 2008 Business Intelligence Studio in a SQL 2005 environment? I'd rather not have to install SQL 2005 / VS 2005 in my development environment. ...