Questions tagged [business-intelligence]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
113 views

SAP BO Freehand SQL date formatting (Oracle db)

My original query worked perfectly via SQL Developer: select * from [table] where DT_CURRENT_DT = '15-OCT-18' However when ran via freehand SQL in SAP BO I got no results. After running the query ...
0
votes
0answers
14 views

How to optimize storage of sales details with multiple products in each sale in Microsoft AccessDb

I have created an accdb with customers and products tables. Now, I want to know how to store the sales order details in the Sales table, WHEN each sale has multiple products, each with different ...
0
votes
0answers
13 views

odi column lineage query

I have no odi experience and i have inherited an oracle data warehouse fed by odi implementations. I need to validate the source to target flows for several fields.My first attempt is to try to create ...
1
vote
1answer
1k views

How to load .dat files to oracle database

I have .DAT files extracted from telecom switch. I want to upload this file to an Oracle server using IBM data-stage ETL tool. Unfortunately these files are not readable format. This is a picture ...
2
votes
0answers
44 views

How to handle / model “cost of provided spare parts per PO line item” where one spare qty is divided between multiple line items? / Postgres 11

Problem My objective is to help improve the data modeling / handling of my company’s present cost-of-goods [‘COGS’] calculation. Everything in the current Postgres 11 table structure is pretty ...
0
votes
1answer
59 views

error in SSIS - [SQL query execution task] Error: The binding name of the results must be zero for the complete result set and the XML results [closed]

I have an Execute SQL task that returns "Full result set". Despite that, the task fails. Please how can I fix it ? [SQL query execution task] Error: The binding name of the results must be zero for ...
1
vote
2answers
91 views

Strategies/Resources for implementing data lineage in an ETL process?

I'm struggling to articulate my need here. I've been tasked with developing a significant ETL process dealing with warehouse item costs in a major grocery chain using the full Microsoft Stack. I'd ...
0
votes
1answer
24 views

Add a years field to a date field?

I have the below fields and would like to add the contract_term field to the date field: Contract_Term: Years Date: YYYY/MM/DD For example: 3(contract_term) + 2019/01/01(date) = 2022/01/01 What ...
29
votes
6answers
503k views

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How ...
2
votes
1answer
2k views

'Refreshing' SSRS subscriptions (parameter values not valid due to lack of data in the tables)

In a place where I work we have lots of subscriptions set for SSRS reports. Some reports have as many as 100 subscriptions set up. Our data warehouse is refreshed every night, with all the data ...
0
votes
0answers
21 views

How can I filter first then show values in BI?

As my title, I'm in this trouble. When I create a BI publisher report, it's show all of value, I just can filter after that. Can someone tell me know how can I filter values before show it in BI ...
22
votes
2answers
38k views

What are Measures and Dimensions in Cubes

I'm very new to Microsoft Sql Server Business Intelligence and Analysis Service(but I'm programming for years with SQL Server).Can any one describe Measures and Dimensions in Cubes in Simple words(If ...
9
votes
2answers
3k views

Will SSRS be extinct soon, and PowerBI the new model?

I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft ...
0
votes
1answer
71 views

Business Intelligence for developers

I'm a developer with apps backed with SQL databases. I want to give my CEO access through BI self-serving tools such as PowerBI or Tableau. My issue is that the affordable tools all seem to require ...
1
vote
2answers
3k views

Import data into MySQL using Talend Open Studio

I have been trying to import CSV data about 60 MB; it contains about 400,000 rows, which should not be too much. I tried these ways to import the data: MySQL Workbench - it took about two hours!!! ...
0
votes
1answer
43 views

SSRS and DBA Scope

Just a quick questions regarding DBAs, recently I was asked about the scope of DBA in terms of SSRS and BI, in your experience who handles and maintain/configure your SSRS, is this part of the DBA or ...
0
votes
1answer
703 views

Load New Foreign Key in Facts Table, When Update Dimension with SCD Type 2

I'm working on the production of a Data Warehouse with SSIS, and today we create the first dimension with SCD of type 2. The fact table is linked in the DIM_CIPESSOA dimension through the idcipessoa ...
2
votes
1answer
681 views

Data into Star Schema's fact or dimension table?

I'm working on creating a Star Schema for my internship that I want to use for reporting on the company's pre-sales process. The aspects of the pre-sales process that I want to report on, are: Sales ...
3
votes
2answers
1k views

Always On Availability Groups as a Secondary Read Only Database [closed]

I am working on setting up a secondary copy of our prod DB for Data Warehousing and even something we can possibly use to offload other processes and reporting on. Basically just a read only copy of ...
1
vote
0answers
182 views

Where to start for DW/BI project?

I work for a small technology MSP. Having just completed my Bachelor's in Information Science, with a focus in data science, my boss has asked me to build a data warehouse (I think he really means a ...
2
votes
3answers
886 views

How to create a normalized database to manage inventory for a small business? [closed]

I am writing a Java application to manage the inventory of a small furniture business. I know little about databases, I have a bit of experience with SQL queries and more experience with Java ...
0
votes
2answers
53 views

Is ELT appropriate for life critcal applications such as Medical Systems when converting to a new application? [closed]

My small experience with ELT and reading makes it look like it is mostly for development. Because the data is not cleaned up like in ETL that makes me think the new application will need to adapt its ...
0
votes
1answer
2k views

Complicated SSRS layout - is that possible?

I have been ordered to do a report with a pretty sophisticated table layout. Okay, it's not that sophisticated, but we all know how SSRS is with those things. I am pretty certain that layout cannot be ...
0
votes
1answer
1k 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
vote
1answer
846 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 ...
2
votes
1answer
68 views

Which BI solutions cooperate with Postgres database and aren't too expensive? [closed]

I'm looking for solution letting me and my team track changes in Postgres database with daily updates. Data doesn't have to be updated instantly, once a day is enough. We use Excel/Google Sheet ...
2
votes
2answers
2k views

Have a separate database for data warehousing?

I have built a typical web application using PHP and MySQL for enterprise usage. The MySQL database is 3NF as much as possible. However, as time goes by, the requests for the data appear to be more ...
1
vote
1answer
506 views

Star Schema - One dimension or split

We have a Data Warehouse, which has two dimensions, Product and ProductLine. Product has just one entry and there is just one ProductLine with a description that changed from transport to Transport. ...
2
votes
0answers
486 views

BI - Sales Fact Table Header and Detail Dimension

I have a FactSales table that is down to the line item. I also have a sales order detail dimension that contains attributes that don't belong in the fact table. Now, I'm in need of incorporating ...
3
votes
1answer
2k 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. ...
3
votes
1answer
123 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 ...
0
votes
2answers
62 views

What can be used with SQL Server 2014 native tools, for Business Inteligence?

We're trying to achieve better reports using native tools from SQL Server 2014. I'm a DBA, and I don't know so much about c#, c++ and etc. I know also, that we have Analysis services, SQL Server ...
1
vote
1answer
665 views

SSIS push and pull performance

After reading Which one is more efficient: select from linked server or insert into linked server? I wonder if this is true also for SSIS? For example, I have 2 SQL Servers (A and B) and SSIS ...
1
vote
1answer
4k views

Business Intelligence Development Studio installation for Visual studio 2010 problem

I want to install Business Intelligence Development Studio for doing report development in Visual Studio 2010, however in my installation process, I cannot find BIDS in the feature selection. What I ...
4
votes
2answers
3k views

For a standby workload of long running analytical queries, is it better to turn on hot_standby_feedback or set max_standby_*_delay settings to -1?

When spinning up a hot standby server specifically for BI/Analytics purposes where long running queries may be common, is it better to turn on hot_standby_feedback or set the max_standby_*_delay ...
1
vote
1answer
479 views

SQL Server + Microsoft Business Intelligence — free version or online learning environment?

I have some experience writing queries and stored procedures in SQL server. I would like to learn how to use the Microsoft Business Intelligence tools (SSIS/SSAS/SSRS). There are loads of books, ...
8
votes
4answers
2k views

What advantages does in-memory OLAP have over traditional systems with significant memory?

Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)? For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where ...
8
votes
1answer
16k views

Best approach for populating date dimension table

I am looking to populate a date dimension table in a SQL Server 2008 database. The fields in the table are as follows: [DateId] INT IDENTITY(1,1) PRIMARY KEY [DateTime] ...
3
votes
1answer
332 views

BI - Cube Concept and MDX Query Help [closed]

In a Mondrian Schema, I have a fact table for Sales, a dimension table Time and a dimension table Client. I need to create a Saiku report where i can show how many clients joined per year. I have a ...
17
votes
2answers
2k views

Recalculate Time Dimension in BIDS

I'm using BIDS to create a cube in SSAS 2008 r2. I used the wizard to create a time dimension. Part of that configuration is selecting a date range. After creation, I realized that I needed a wider ...
1
vote
2answers
2k views

Business Logic in Data Warehouse

my question is: Should business logic be stored in the data warehouse data store? Or should it only exist in the reporting applications? To give a more concrete example: In the CRM operational ...
0
votes
0answers
44 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
1answer
473 views

Change SSIS package location (REPOST from SO) [closed]

My SSIS Package are located in shared drive with a long path name. To make the packages easier and not to remember long path name, I use "Map my network drive" option and use X: drive as an alias to ...
2
votes
2answers
4k views

2 SSRS Instances, one in native mode and one in sharepoint integrated mode with PowerPivot and PowerView on same server

Wanted to know if I can have two SSRS instances on the same server, one in native mode and one in SharePoint integrated mode. I have one SSRS instance in native mode on a SQL server default instance ...
2
votes
3answers
117 views

Data Warehouse attribute that describes its timeframe?

I am writing a document about a Data Warehouse system, and would like to know if is there a single word (noun) that describes the DW attribute of how many time it contains? I mean, if a DW contains ...
0
votes
2answers
419 views

Daily snapshot fact table

I have a list of products per costumer. Costumers can delete or add products to their list. I want to know in each day what is the list of products (and count) by costumer. My first approach is to ...
-1
votes
1answer
2k 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 ...
4
votes
1answer
893 views

What known strategies, if any, can I use to validate a Slowly Changing Dimension?

I have a customer dimension in our data warehouse (SSAS 2014 Multidimensional). It is set up as a Type II SCD, with just Start and End Date fields to track changes. (null end date = current). As our ...
3
votes
1answer
68 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. ...
-7
votes
3answers
327 views

Is business intelligence (BI) primarily a technical project or a business project? [closed]

I am currently involved in the planning stages for a Business Intelligence (BI) project in our company. We are attempting to understand many facets of the business, and as such the technical side ...