Questions tagged [business-intelligence]

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

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
72 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. ...
3
votes
0answers
2k 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 | ...
2
votes
0answers
45 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 ...
2
votes
0answers
496 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 ...
1
vote
0answers
190 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 ...
0
votes
0answers
18 views

Use DBSNMP for Database Usage Tracking Credentials without adding manually

Enterprise Manager Cloud Control 13c Version 13.3.0.0.0 Oracle BI Publisher 12.1.3.0.0 For each target we have use DBSNMP credentials. We have two type of credentials for each target: Monitoring ...
0
votes
0answers
15 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 ...
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 ...
0
votes
1answer
132 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
1answer
53 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
76 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 ...
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
0answers
71 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 ...
-1
votes
1answer
59 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.