A collective term for the field of developing reporting and analytic systems, often associated with data warehousing.

learn more… | top users | synonyms

2
votes
1answer
55 views

How to show when loan was paid off

First time posting but have been a reader for over 10 years. I have a need to show when a loan was paid off regardless of the rolling balance from refinancing/taking out additional loans. In the ...
2
votes
1answer
43 views

Are there best practices or standardized syntax for writing transformation logic?

This may not be the appropriate forum, but its the closest I could find. I write a lot of source to target mappings for work. These documents just describe the operations/logic/transformations/etc. ...
0
votes
1answer
545 views

RapidMiner Not Connecting To SQL Server Database Connection

I recently installed RapidMiner and tried connecting the application to my MS SQL database connection via the Manage Database Connections feature. I have followed video tutorials on integrating SQL ...
-1
votes
1answer
279 views

Adding a Quarter column every three months in a report in SSRS

This is driving me a bit bonkers. It seems like it should be easy but SSRS has me stumped. I want to create a report of our customers displaying the monthly sales totals and display the Quarter ...
-1
votes
1answer
38 views

Use Oracle 10g BI enterprise edition with Oracle 11g database

Can i use Oracle 10g BI enterprise edition with Oracle 11g database. please tell. Thanks.
3
votes
0answers
781 views

How to insert values into Bridge Table in star schema?

I am modelling my database with respect to star schema with bridge tables. My master Table looks like below. I need to convert this format to star schema. MasterTable StudentNumber | Subject1 | ...
0
votes
0answers
13 views

Star Schema from Relational Database

I'm a newbie to data warehousing and I've been reading articles and watching videos on the principles but I'm a bit confused as to how I would take the design below and convert it into a star schema. ...
0
votes
0answers
59 views

SSDT - Unresolved Reference to temporary table in linked server

Here's the scenario. I am extracting data from a table in an Oracle database via a linked server as part of an ETL process. I am developing the solution in Visual Studio 2013 with SQL Server Data ...
0
votes
0answers
23 views

Is it possible to have SSRS generate report while a parameter is being typed?

I have only been using SSRS for a few weeks now and from what I have seen, I know that we create a dataset, define parameters (I do it by using a paramaterized stored procedure and linking that to a ...
0
votes
0answers
48 views

Merge data using Integration Service

Please Consider this scenario: I have a table in my database. I want move this data in my OLAP database using SSIS.I can move all record from my table to OLAP database.The problem is I don't know how ...