BI

Great Reads

A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation

by Niladri_Biswas

This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.

Requirements Eng for Traditional and Big Data Business Intelligence

by Daniel Joubert

Comparing Requirements Engineering for Traditional and BigData Business Intelligence

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

by Jesus Carroll

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

Run All Subscription Reports At Once in SSRS Manually

by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

Latest Articles

The Ways to Make Pre-aggregation in Multi-dimensional Analysis Effective

by Jerry Cruise

For a large number of other common requirements, we need to use a computing engine to implement efficient hard traversal to meet.

Exploring Data Cubes on NSimpleOlap (Alpha)

by Carlos Conceição

Current features of NSimpleOlap library

Presenting NSimpleOlap (Alpha & Unstable)

by Carlos Conceição

NSimpleOlap is embeddable .Net OLAP library for use in console, desktop, or other types of applications.

Requirements Eng for Traditional and Big Data Business Intelligence

by Daniel Joubert

Comparing Requirements Engineering for Traditional and BigData Business Intelligence

All Articles

top

BI

A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation

27 Apr 2011 by Niladri_Biswas

This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.

SQL

Win7

Windows

SQL-Server-2008

SQL-Server

Dev

SSIS

Requirements Eng for Traditional and Big Data Business Intelligence

27 Apr 2016 by Daniel Joubert

Comparing Requirements Engineering for Traditional and BigData Business Intelligence

Dev

big-data

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

10 Feb 2016 by Jesus Carroll

Run All Subscription Reports At Once in SSRS Manually

5 Sep 2013 by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

Presenting NSimpleOlap (Alpha & Unstable)

22 Apr 2021 by Carlos Conceição

NSimpleOlap is embeddable .Net OLAP library for use in console, desktop, or other types of applications.

.NET

Dev

OLAP

why is this a mistake?

26 Apr 2011 by zhaoyilong1

I am doing a data mining job, but there are many mistakes I don't know how to solve them.Firstly, I created a mining model: decision tree:create mining model [DecisionTree_MemberLevelPredict]( stu_ID text key, stu_gender text discrete, stu_birthyear text discrete, stu_education...

SQL-Server

SQL-Server-2005

Sub-query which returns several lines

29 May 2020 by #realJSOP

Dude, learn how to format your code so we can read it. Beyond that, here is your code formatted. Note the comments: SELECT Q.DTNUMEXE ,Q.DTMOIEXE ,Q.DTANNQIT ,Q.DTMOIQIT ,Q.DTCODBRC ,Q.DTSERQIT ...

What is needed to embed power BI in a web page

6 Apr 2021 by SeanChupas

Never trust licensing or legal answers from some website like this. If you have a licensing question you have to ask Microsoft. Also, Microsoft has a document on how to do this, Embed a report in a secure portal or website - Power BI |...

Codeproject broken after update

17 Jul 2023 by Dave Kreskowiak

Ask your question in the dedicated forum for CodeProject.AI Discussions[^]

How do I add specific animals to AI recognition

15 Oct 2023 by OriginalGriff

This would be better posted in the dedicated forum: CodeProject.AI Discussions[^]

import data from one excel sheet to multiple tables in sql server using ssis package

18 Apr 2011 by Sandeep Mewara

Good to know, but it does not work like this here. I am sorry but there is no quick question here. This is your college project, you should put some effort.We expect you to put some time in trying the issue that you are facing and then some time in formulating the question while posting...

SQL-Server

SSIS

datamining problem: varchar mistake

25 Apr 2011 by Costica U

I think you should change varchar(50) to TEXT.

SQL-Server

SQL-Server-2005

datamining problem: varchar mistake

25 Apr 2011 by zhaoyilong1

The bold part is where it meets mistake : datamining problem: varchar mistakecreate mining model DecisionTree_LevelPredict( stu_ID varchar(50) key, stu_gender varchar(50) discrete, stu_birthyear varchar(50) discrete, stu_education varchar(50) discrete, stu_levels varchar(50)...

SQL-Server

SQL-Server-2005

why is this a mistake?

28 Apr 2011 by Rajesh Lagaria

logic for query :SELECT T1.ID,T1.gender,T1.birthyear,T1.education,T1.levels FROM dbo.customer T1not use as on table name:exmp: select T1.id as idname FROM dbo.customer T1

SQL-Server

SQL-Server-2005

finding a product using barcode

30 Apr 2011 by Nish Nishant

Not sure what tools/language you are using, but you might want to look at a service such as http://www.upcdatabase.com/[^]That's just an example, there must be other similar services and probably better ones out there.

How can I see mining structure in ssas?

4 May 2011 by zhaoyilong1

How can I get(see) my mining structure in sql server 2005 BI development studio after I create one mining structure and one mining model in SQL server management studio in DMX?I cannot see one mining structure after I have done it in the management studio...

SQL-Server

SQL-Server-2005

Graphical report using SQL 2008 (BI Development Tool)

1 Aug 2011 by Soft009

HI all,I want to create a graphical report using reporting server in sql 2008.I can create normal data reports.But I want to know the steps of creating graphical reports.thanks

Graphical report using SQL 2008 (BI Development Tool)

2 Aug 2011 by thatraja

Here you goSSRS Report Design: Best Practices[^]Beginning SQL Server Reporting Services Part 3: The Chart Control[^]SQL Server Reporting Services: Chart Reports[^]In SSRS, there are things like Table, Matrix, Lists, Chart, Image, etc., to develop rich type reports, go ahead.

How can I see mining structure in ssas?

14 Aug 2011 by S Douglas

Providing your DMX script executed successfullyOpen SQL Server Management StudioConnect to SQL Server Analysis Services on your server instance (this is different than connecting to a normal OLTP SQL Server)Click the plus sign to expand the databases objectClick the plus sign to expand...

SQL-Server

SQL-Server-2005

How to configurate the reporting service configuration management when I want to deploy a report?

10 Sep 2011 by PEIYANGXINQU

How to configurate the reporting service configuration management whem I want to deploy a report?It always let me to fill out the account and password?

SQL-Server

Which website using sql server reporting services capabilities?

22 Nov 2011 by Nikil S

Some Links that would help you.http://msftrsprodsamples.codeplex.com/[^]http://sqlserversamples.codeplex.com/[^]

showing column groups data in row - SSRS 2008

23 Apr 2012 by vikram_shinde

SSRS

reporting

Merge CSV files having different columns using SSIS

24 May 2012 by vikas kunte

I have a set of CSV files in a folder. Some of the columns in all files are same.I need to merge all the CSV files into one CSV or an Excel using SSIS. The resultant merged csv or excel file must contain all column names.I am glad to recieve ur help and comments.File1.CSVID Name...

SQL-Server

SSIS

Merge CSV files having different columns using SSIS

24 May 2012 by Jim Jos

I hope you are using Sql2005 and above.. Following links will help to create Two flat file sources and you could use a Merge Transformation to combine into a single...

SQL-Server

SSIS

Get datediff from using two different rows

9 Jul 2012 by Lee Trueman

I have a dataset that contains on/off times for a product.i.e.ON = 1OFF = 0DeviceID Event EventDateTime1 1 12/07/2012 19:001 O 12/07/2012 19:101 1 12/07/2012 19:151 O 12/07/2012 19:451 1 ...

reporting

Get datediff from using two different rows

10 Jul 2012 by Sandeep Mewara

Expression should be ok. I guess, there might be an error for the first row evaluation(as Previous for it will give Nothing).Try:=IIF(RowNumber("GroupbyCategory") Mod 2, Nothing, IIF(Fields!EventID.Value = 0, DateDiff("h",Fields!EventDateTime.Value, Previous(Fields!EventDateTime.Value)),...

reporting

How to get the last item in a complex mdx query

8 Nov 2012 by yan0lovesha

I am customizing a report in TFS, the report include a matrix used to show the result result of a Test Plan and Test Cases. Currently the report shows all the Test Runs result for each test case. e.g. There is a test plan contains 2 test cases, tester run each test case 2 times. The first...

SQL

SSRS 2008 : Parameters are not passed to Web Service Method (Xml Data Source)

20 Aug 2013 by omprakash katre

I am facing problem in SSRS 2008. The parameters of rdl query for an web service API are not working. Instead the parameters are parsed with default values are workingMy Query in the rdl file is ...

SSRS 2008 : Parameters are not passed to Web Service Method (Xml Data Source)

22 Aug 2013 by Anh Nguyen Trong

Please try this:It is more simple than yoursGetOrders1 - Method in WebserviceOrderID - Parameter of Webserice.ElementPath- Type exact column name in Database http://tempuri.org/GetOrders1

Microsoft SQL Server Report Designer wizard Unable get IVSMDDesignerService (mscorlib)

7 Dec 2013 by Shoukat Ali Laghari

Hi,I am unable to create a report from SSRS Report wizardI am using SQL Server 2008 R2 Business Intelligence Studio to create a report via Report Wizard and I gone through the following steps while creating the report:1. Click File-->new-->Projects-->Reporting Server Project Wizard...

SSRS

How do I link the date dim to fact table in my cube

1 Feb 2014 by Member 10565929

Hi there;I am creating a new cube in Visuel Studio & the dimension calnder is linked to the fact table thorugh transaction date in the fact table & dates in the dimension , both data types are date type , the cube basically retrieves the sales per product per date , the cycle hierarchy is...

Migrated BI projects to support sql server 2012

14 Mar 2014 by Christian Graus

If you changed your SQL to use SS2012 constructs, then the only way to fix it, is to change them back.But it looks to me like you're trying to deploy a SS2012 backup to SS2008. This also won't work. You can use a shared server connection to write SQL to pump the contents of one DB to...

SQL-Server

creating BI application

1 Dec 2014 by Sergey Alexandrovich Kryukov

Please see: https://docs.oracle.com/cd/E10783_01/doc/bi.79/e10759.pdf[^].—SA

Foreach File Enumerator missing in 2008 BIDS

9 Jul 2015 by Math08avan

I resolved the issue. After reinstall the 2008R2 BIDS, Foreach File enumerator is working.

How do I Load Data from Multiple Source (Text & Excel) Into Single Table Using SSIS

11 Oct 2015 by Member 12049612

Greetings,I am unable to load data from multiple sources(Excel and Text) into single SQL server table using SSIS. As in am new to this subject, couldn't find solution for this. When I am browsing for solutions online I found this page(Code Project) and found something interesting about this...

SQL

SSIS

Error logging from child package ssis

5 Dec 2015 by ssisnewb

Hello,I have a parent package and multiple child package . Parent package should log the error details on the child into a log file.I guess I need logging on the parent enabled to do this.What else do I need?Do I need the Eventhandler in the child package? Should this be a script...

HandleError

SSIS

SSIS Verify if SQL instance is up

29 Dec 2015 by Member 11994835

I am currently creating a package that uses a dynamic Connection string. The values used in the connection string are pulled from a SQL table So they change on each run of my foreachloop. I would like to have it set up so that if a server is offline or the SQL instance is down the connection...

SQL

VBScript

SSIS

Data warehouse: Orders, Sales and Revenue facts

25 Jan 2016 by Purna Chandra Sasmal

Based on your data volume, you can decide.if it is less, you can create view on top of this and have the total sum of order, sale and revenue corresponding to dimensions.or, you can create tabular model.

How do I Load Data from Multiple Source (Text & Excel) Into Single Table Using SSIS

27 Jan 2016 by Chinna2903

If all the records in the file need to be inserted to a single table we can apply this scenario.1. Create multiple flat file sources [note that this could be possible if you have same schema in all the files].2. Merge all the sources through merge component.3. Load it to the destination...

SQL

SSIS

How to crate physical column in OBIEE physical layer using an expression

21 Mar 2016 by Raju9959

I'm new to Oracle BI, I may ask some simple questions for what I could not able to find solution.I want to join this 2 tables in oracle BI physical layer, how to perform itTable1 ID NameA AppleB BallC CatD DogTable2Name PriceApple 10Ball 15Please can anyone...

Oracle

Mysql trigger for pivoted table

30 Apr 2017 by Member 13027553

Hi, The story is that I have two systems taking data from two tables. due to the lack of proper DB structure. Here's the first table for CodeIgniter Admin Page. ╔═════╦═════════════╦══════════════╗ ║ ID ║ ProductName ║ ProductValue ║ ╠═════╬═════════════╬══════════════╣ ║ 1 ║ A ...

MySQL

CodeIgniter

Got an error 'an exception of type 'system.nullreferenceexception' occurred in devexpress.dashboard.v16.2.core.dll but was not handled in user code'

29 May 2017 by David_Wimbley

Given that you are using a 3rd party library that appears to have had an exception within its code (although its probably an issue in your usage to be honest) I would suggest you direct this kind of question to their forums. DevExpress Forums - Presentation Components, IDE Productivity Tools,...

C#7.0

MVC

DevExpress

Pentaho medrain data selection.

4 Jul 2017 by KarstenK

Take a look into the Pentaho Mondrian Documentation for reading the data.

In oracle BI report publisher, I need to set querter start and end date as fromdate and todate parameter.

19 Jul 2017 by Er. Puneet Goel

I am a newbie to Oracle Bi Publisher reports. I have FromDate and ToDate parameters. I need to set it Quarter Start and End Date. Please help. What I have tried: I tried to calculate the querter start end date using functions below but failed. [Date Parameters in OBIEE]

Oracle

Building custom visual(venn diagram) in power BI

19 Jul 2017 by Member 10498670

I am trying to create a venn diagram visual in Power BI using D3.js. I have Found one running example of venn Diagram (https://github.com/benfred/venn.js/). But I am experiencing some issues in using some methods of this javascript file in our typescript file. We have already created a...

Typescript

WTD calculation not working in SSAS

21 Aug 2017 by Member 11479116

Hi I am creating WTD Calculation into SSAS but it is mot working as my expectations,I want to Week to Week data from this measure for example when I select Sunday it will return 7 days data from Sunday to Saturday. When I select Monday it will return Monday to Sunday Data. What I have tried: ...

SSAS

About set profile input XML with a variable data profile task SSIS

20 Sep 2017 by leocode7

Hello Everyone, Please Tell me if is possible to set the property ProfileInputXml of the Data Profile Task in SSIS with a variable, because i want to set the property dinamically with expression options, I Attached a image to show more better the problem. Bugs - Google Drive[^] If there is a...

Binary conversions in C

21 Jan 2018 by Avni Salhotra

#include // library of functions for this chip #include // library containing printf() function #include "configureUSART.h" // library for configureUSART(baud) #include "configuration_bits.h" void printCharAsBinary(unsigned char number); void WaitOneSecond(void);...

conversion

microcontroller

Binary conversions in C

21 Jan 2018 by KarstenK

You must understand the so called bit shift operator (>>) which moves the bits of the input to lower side. So a repeating call moves all bits out of the memory. This operator moves the bits of the memory which is interpreted as some variable. To really understand it you must understand that all...

conversion

microcontroller

Vlookup in power query

20 Jun 2018 by Karan_TN

Hi, I am using Power Query (excel 2013) tool to work on vlookup process for large data (3+lakh records). I used "Merge" method and got the result. two questions i am having. 1. Left Outer merge option is similar to VLOOKUP but not the same! In standard Excel, when a match is found, only the...

MS-Excel

For powerapp on power BI - eliminate excel file by onboarding the data

17 Sep 2018 by Member 12824529

I have a PowerApp on a Power BI. The PowerApp gets its data from an Excel file. Is there any way to serialize the data that's in the Excel file within either the PowerApp or the Power BI in order to eliminate the need for the Excel file and have "fewer moving parts?" What I have tried: I...

Excel-2016

Sub-query which returns several lines

29 May 2020 by houssem eddine ayari

SQL0811 : Résultat de SELECT dépasse une ligne. Cause . . . . . : La table résultante d'une instruction SELECT INTO, d'une sous-requête ou d'une sous-requête d'une instruction SET comporte plusieurs lignes. Il s'agit d'une erreur de type 2. Une...

What is needed to embed power BI in a web page

6 Apr 2021 by John Robert Connolly

I am new to power bi and I don't have much knowledge about power bi licensing and what you can and can't do and also what you are required to have to do certain things. My question is what do you have to have for licensing and software...

Exploring Data Cubes on NSimpleOlap (Alpha)

5 May 2021 by Carlos Conceição

Current features of NSimpleOlap library

Postgres, power bi, and timezones

7 Nov 2021 by Corey Bailey 2021

I am bringing in data from postgres into power bi and then using that power bi app in a vue pilot rotation.. I was using an odbc connection but it is too slow so I want to do direct query. However, the server the postgres is on utc obviously....

PostgreSQL

How can I run a batch file when the pc is off and is not connected to any network

10 Jun 2022 by Emilia Kullutwe

I am using WinSCP to connect to my ftp server. I get files from ftp server and saved them in a local folder on my pc. I have a batch script that I run manually everyday. This script synchronizes the files in the ftp server with those in my local...

How can I run a batch file when the pc is off and is not connected to any network

10 Jun 2022 by OriginalGriff

You can't. The key bit here is "How can I run a batch file when the pc is off" When a PC is powered down, the processor is not running, and no applications, scriopts, or batch files can execute on it. If it's hibernated, or sleeping then it's...

The Ways to Make Pre-aggregation in Multi-dimensional Analysis Effective

15 Jul 2022 by Jerry Cruise

For a large number of other common requirements, we need to use a computing engine to implement efficient hard traversal to meet.

Can someone help me get CP to utilize my GPU?

30 Apr 2023 by HomeLabTinkerer

I recently added a Tesla K40 to my VM Host running ESXI 7.0. I was able to get the drivers installed, Cuda 11.2, VM is seeing my GPU and so is CP. For some reason I cannot get the GPU to handle object detection. I have the GPU enabled in Blue...

GPU

tesla

Blue iris and code project - unable to create YOLO detector for model yolov5m

4 May 2023 by Mark Sykes

Blue iris version 5.7.2.6 Code project 2.1.8 Windows 10 Unable to create YOLO detector for model yolov5m This error message seems to be a common issue CodeProject no longer works with BI - any ideas? What I have tried: (also tried 2.1.6)...

Blue iris and code project - unable to create YOLO detector for model yolov5m

4 May 2023 by OriginalGriff

You probably need to ask this in the dedicated forum: CodeProject.AI Discussions[^]

Codeproject broken after update

17 Jul 2023 by Joel Teft

Hi, I am using codeproject with blue iris. I had been using Deepstack AI, but switched to CodeProject starting with version 1.6.6.0. Everything has worked fine through version 2.0.8 until I tried to update to version 2.1.9. The GPL-3.0 face...

Codeproject.ai server goes offline

27 Aug 2023 by glessa01

I was experiencing something similar. Codeproject.ai would go offline after a first detection. Then it would go back online, and it would cycle again after first detection (which occurred frequently). My solution: Under Blue Iris Settings > AI...

Codeproject.ai server goes offline

29 Apr 2023 by Richard Bryant 2022

Since upgrading to 2.1.6 whenever an object is detected by Blue Iris the Server goes from Online to Offline. The first alert in BI shows AI:Timeout and all subsequent alerts show AI: Not responding. It seems as if the installer has an access...

How do I add specific animals to AI recognition

15 Oct 2023 by Chris D_Keir

Hello All I volunteer with the Saving Scotlands Red Squirrels project, and I want to use Blue Iris and CodeProject.ai to assist. I would like to add very specific species to ai, then use my BI system to recognise only them and trigger videos from...

POWER BI / DAX : problem creating a filtered table using an existing measure

N 18 Apr 2024 by AndyW1969

I want to calculate total sales for all dates in a table where the date is less that a specific date. The specific date is stored in another measure. What I have tried: TotSales = /* Does not work if filtering using a pre-existing measure...

Copy Files from One Location to Another and Rename Them after Putting Time Stamp

27 Apr 2011 by Niladri_Biswas

A program to demonstrate the copy files from one location to another and rename them after putting time stamp by using Sequence Container, Foreach Loop Container, File System Task and Script task

Working with Pivot and UnPivot Transformation

9 May 2011 by Niladri_Biswas

This article will describe in simple ways as how to work with Pivot and Unpivot transformation component

Learn Microsoft Business intelligence step by step – Day 1

25 Jun 2014 by Marla Sukesh

In this article we will learn basics about DW, BI, SSIS and ETL Process

VS2010

artificial-intelligence

Visual-Studio

Microsoft

MSBI

Learn Microsoft Business intelligence step by step – Day 2

25 Jun 2014 by Marla Sukesh

Learn Business Intelligence step by step - SSIS Day 2

Create custom transformation component(Email Validator) in SSIS- Step by step

3 Aug 2011 by Niladri_Biswas

In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple

Postgres, power bi, and timezones

7 Nov 2021 by RickZeeland

See answer here: Solved: Time error in data in automatic refresh - Microsoft Power BI Community[^]

PostgreSQL

Got an error 'an exception of type 'system.nullreferenceexception' occurred in devexpress.dashboard.v16.2.core.dll but was not handled in user code'

29 May 2017 by TarunKumarSusarapu

I created Sample MVC devexpress Dashboard application. I got an error 'An exception of type 'System.NullReferenceException' occurred in DevExpress.Dashboard.v16.2.Core.dll but was not handled in user code' while updating the data extract in gloabal.asax.cs. void...

C#7.0

MVC

DevExpress

Which website using sql server reporting services capabilities?

22 Nov 2011 by PEIYANGXINQU

I do want to emulate a similar site,It would be better if there are characteristics, Can you tell me the link?Thank you.

Migrated BI projects to support sql server 2012

6 Mar 2014 by harshal rajkotia

Hi,I have Migrated BI projects to support sql server 2012. But now it's not working on sql server 2008. This is urgent project need. Please help.

SQL-Server

Foreach File Enumerator missing in 2008 BIDS

26 Mar 2014 by Math08avan

I am using 2008 BIDS. In my 2008 BIDS Foreach File enumerator missing in the foreach loop collection list. How do i resolve this issue?

Data warehouse: Orders, Sales and Revenue facts

25 Jan 2016 by Member 12286600

I need help on how to present or report from multiple fact tables:1. Orders (has all items that were ordered)1. Sales (has all sold items, spanning multiple years)2. Revenue (has revenue from items sold in current year)As you can see Sales amount Revenue amount.We have separated...

Got error while calculating the value by dividing two calculated fields in expression editor

20 Jun 2017 by TarunKumarSusarapu

In Expression editor I have two calculated fields and the values are 19000 and 20000. On dividing both it has to show 0.95. But it is displaying error. What I have tried: This is my expression [Agreed_Data] / [Current_Forecast_Data] For Agreed Data the expression is ...

SSRS

Pentaho medrain data selection.

4 Jul 2017 by rehanNiaz

Hi, I need little help regarding pentaho. I have already implemented graph in PHP. Now I just want to use same design and pull data from pehtaho cube. is it possible ? What I have tried: Hi, I need little help regarding pentaho. I have already implemented graph in PHP. Now I just...

Binary conversions in C

21 Jan 2018 by Avni Salhotra

I have solved this thank you all for help

conversion

microcontroller

Can someone help me get CP to utilize my GPU?

30 Apr 2023 by Dave Kreskowiak

The CodeProject AI forum is over here[^].

GPU

tesla

Codeproject.ai server goes offline

29 Apr 2023 by Dave Kreskowiak