Stack Overflow
Stack Overflow

Questions tagged [bi-tool]

Business Intelligence Tools to build the queries within seconds using a drag-and-drop interface without any SQL skills

Business Intelligence Tools to build the queries within seconds using a drag-and-drop interface without any SQL skills

27 questions
0
votes
1 answer

Complex requests with REST API

I am wondering if it is possible to adhere to REST principles when creating what will essentially amount to a BI tool. In my scenario I have high data volume with 100,000's of IDs (frankly more than this but for the sake of this example let's go…
StormShadow
  • 171
  • 1
  • 6
0
votes
0 answers

Visual Studio 2013 c# web forms not visible

I have installed en_visual_studio_ultimate_2013_x86_dvd on windows 10. and SQL server Business Intelligence data tools . now i getting only Analysis and Integration and reports package in New Project options in visual studio . when i uninstall…
Cookie
  • 25
  • 1
  • 10
0
votes
2 answers

BI connector from MongoDB to MySQL

Can anyone suggest a reliable BI connector to MongoDB either paid or free? I have already evaluated BI connector provided by Mongo in their Enterprise edition but we are using Mongo community version. I already have a BI tool. I just want the…
Praveen Kumar
  • 19
  • 3
0
votes
1 answer

How to contcatenate multiple rows into a single row grouped by key column?

I have XML as source and target will be text file. I am pulling data from 2 tags in xml one is Individual and and other is Professional designation tag and joining them based on Individual Internal Id key column. We have Type column in professional…
Rav
  • 103
  • 1
  • 1
  • 8
0
votes
2 answers

How to create an Archive file form flatfile with timestamp in informatica which should contain same target location?

The Scenario is I have a flat file as source and I need to create 2 target files in same location. One is target file and other one is Archive file(along with time stamp)?
Rav
  • 103
  • 1
  • 1
  • 8
0
votes
1 answer

Oracle BI 12c ,new repository not show in subject area after "RPD upload complete successfully" message

I used data-model-cmd.sh command to upload new RPD file and when i got "RPD upload complete successfully", there is no new repository in subject area in OBIEE 12c console on real time. Some time I should refresh multiple time the page and restart or…
soheilz92
  • 127
  • 2
  • 19
0
votes
1 answer

Error while creating calculated field in Tableau

I have a Baseball Player Data file. I want to create a calculated column called "Quadrant" which will categorise the types of players into 4 categories. My code is: CASE WHEN ([OBP]<=PERCENTILE([OBP],50)) AND ([BB/K]<=PERCENTILE([BB/K],50)) THEN…
Trisa Biswas
  • 555
  • 1
  • 3
  • 17
0
votes
2 answers

Impossible to load data set[country_name] due to the following errors the paramerter has no value[par_country];

Step 1 I have created a Dataset which has parametric query select city from country where country=$P{par_country} I have added the attributes and on preivew it is working fine. Step 2 Now i have created a LOV(List of values) with query select…
Akshay jain
  • 555
  • 1
  • 7
  • 22
0
votes
1 answer

SpagoBI Javascript SDK - Parameters not working

I am using sbisdk-all-production.js to integrate SpagoBI cockpit in external web-app. Following is the code snippet I am using to load cockpit in web-app: var url = Sbi.sdk.api.getDocumentUrl({ documentLabel: 'cockpit__xxxxxx' …
Chaitanya
  • 331
  • 2
  • 17
-1
votes
1 answer

Calculation based Fixed LOD expression

I am trying to Sums the Spend based on CampaignName, campaign start date and Today's Date( today Date - 1). Below is the Calculation Field created by me {FIXED [CampaignName] : SUM({ FIXED [CampaignName],[Date]>=[CampaignStartDate] AND [Date] <=…
SumitKumar Pandey
  • 3
  • 3
-1
votes
1 answer

IIf function doesn't work (Visual Studio 2013 BI Tools)

I'm using Visual Studio 2013 (with SQL-Server 2014, Reporting Services and BI Tools) and I try to add an simple "iif" expression but the compiler returns an Error (value = -1073741511) I tried: = IIf ( 3000 > 1000, "True", "False" ) Is it possible…
Kroenig
  • 644
  • 7
  • 16
-2
votes
1 answer

How to Show all the data after applying Filter in Zoho Analytics with 0

I Have data of customers shopping with shopping date. Now I have applied a filter on the shopping date. But it eliminates the customers who have not bought something on given dates. How can I list all the customers whether they have bought something…
Chirag Gwalani
  • 1
1
2