Click here to Skip to main content
15,847,748 members
Home / Discussions / Database
   

Database

 
AnswerRe: Oracle, inner join and substr function Pin
Eddy Vluggen20-Mar-15 11:21
professionalEddy Vluggen20-Mar-15 11:21 
AnswerRe: Oracle, inner join and substr function Pin
Jörgen Andersson20-Mar-15 14:20
professionalJörgen Andersson20-Mar-15 14:20 
GeneralRe: Oracle, inner join and substr function Pin
Ludwing RS23-Mar-15 9:02
Ludwing RS23-Mar-15 9:02 
QuestionSSRS merging main header of two columns into one and then splitting subheadings Pin
indian14316-Mar-15 13:39
indian14316-Mar-15 13:39 
QuestionSSRS Report not allowing to edit name of the field Pin
indian14316-Mar-15 12:44
indian14316-Mar-15 12:44 
AnswerRe: SSRS Report not allowing to edit name of the field Pin
Richard Deeming17-Mar-15 4:42
mveRichard Deeming17-Mar-15 4:42 
GeneralRe: SSRS Report not allowing to edit name of the field Pin
indian14318-Mar-15 13:46
indian14318-Mar-15 13:46 
QuestionHelp with SSAS project Pin
rafael.avaria16-Mar-15 8:10
rafael.avaria16-Mar-15 8:10 
I'm working as devops in a SSAS project with SQL Server .
My final goal is automatise the deploy process of the olap cube (or SASS), I'm getting hard time try to do it.

Anyone have experience in this kind project?.
Can provide me information or material to study

What I need to do is find a way to do all the process by command line.
I have some parts of the overall process already resolved.
But what keep me frustrate is find a way to process the cube by command line

Background of the project
The datasource of the project is a virtual database,in consecuence, it's can read information for any data sources (other databases like SQL Server, Mysql or even documents like XML, spreadsheets ) and expose as single source to the cube.
more info in this link.

Before to start process, for performance reason it's necessary to stop any scheduled jobs in the cube.

When the process start, it's going to fetch the information from the vdb if there are 50 million records from legacy datasources. Then they are going to stored into the cube cannot do anything to avoid this

After finish to process, The final step is run some unit test made with NBI testing framework .

After finish to process i need to run some test made with NBI testing framework over the cube.
For example
> > If the field fiscal_year exists in the date dimension
> > the query X is not doing a fullscan
more info in NBI codeplex site
QuestionProblem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 7:38
delgaillo12-Mar-15 7:38 
AnswerRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 15:51
professionalMycroft Holmes12-Mar-15 15:51 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 23:12
delgaillo12-Mar-15 23:12 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 23:14
professionalMycroft Holmes12-Mar-15 23:14 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo28-Sep-15 1:17
delgaillo28-Sep-15 1:17 
QuestionCreating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:25
Member 115083508-Mar-15 15:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 16:33
professionalRichard Andrew x648-Mar-15 16:33 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:42
Member 115083508-Mar-15 16:42 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 16:48
professionalRichard Andrew x648-Mar-15 16:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:59
Member 115083508-Mar-15 16:59 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 17:21
professionalRichard Andrew x648-Mar-15 17:21 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:25
Member 115083508-Mar-15 17:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:56
Member 115083508-Mar-15 17:56 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 18:18
Member 115083508-Mar-15 18:18 
GeneralRe: Creating SQL statements in Access Databases Pin
Chris Quinn8-Mar-15 23:07
Chris Quinn8-Mar-15 23:07 
AnswerRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 7:51
Abdulnazark9-Mar-15 7:51 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 18:01
Member 115083509-Mar-15 18:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.