Releases

The following list contains official releases (added on ftp and for download) with description of fixes and additions.

Service builds exists between these main releases so check dates to see what is fixed. Internal builds are available on request, on ftp and pbsndfile.

Click here for download page.

Profitbase Studio 2023

2023 release 26.january 2023 Profitbase Studio 2023 Build 4288
  • (4286) Fix Time Dimension to support hierarchy level translations.
  • (4284) Remove support for Azure Datalake (obsolete)
  • (4282) Adjust Time Dimension week rule defaults.
  • (4281) Fix/update Azure Blob Storage usage with Powershell template updates.
  • (4276) Bump version from 6.6 to 2023
  • (4275) Support for SQL2022 (SMO,DTS and SSAS)
  • (4273) Update of .Net Framework from 4.6 to 4.7

Profitbase Studio 6.5

 6. release  23. February 2021 Profitbase Studio 6.5 Build 4208
  • (4208) Fix Data Source SQL builder: Ensure succeeding tables in folders are visible even if preceding tables in the folder fail to load. (Fix applies to internal data warehouse tables in external data sources, not data warehouse sources)
  • Build 21. February 2021 Profitbase Studio 6.5 Build 4206
  • (4206) Fix Data Source SQL Builder: corrected drag drop of staging tables.
  • (4205) Fix Module Wide Dimension Member Scan: corrected insert of new item(s) with attributes using value column.
 5. release  29. January 2021 Profitbase Studio 6.5 Build 4199
  • (4199) Update Server and set correct name of SQL Server 2017 BatchParser dll. (last versions was delivered with wrong name ..BatchParse.dll).
  • (4198) Sub Dimension fix: correctly regenerate sub dimension triggered by scan.
 4. release  1. December 2020 Profitbase Studio 6.5 Build 4192
  • (4192) Fix dialog order to prevent hiding them behind main window or other dialogs.
  • (4191) Wide Dimension fix: Prevent formatted name columns to cut identity columns longer than 20 chars. 
  • (4188) Template: Installation of solution templates is refurbished. Fixed dialogs, sequence and restore of data.
  • (4186) Fix in folders in Datasource: Prevent dragging content to wrong parent.
  • (4178) PoSh: Referencing of SMO Sql Server version changed from e.g. 15.0.0.0 to 15.
  • Updates on distribution of SQL 2017/2019 files.
 3. release  9. October 2020 Profitbase Studio 6.5 Build 4163
  • Added missing SQL server 2019 files for PB Server.
  • (4163) SSAS Dimension fix: update name for existing dimension in Create/Update Dimension command.
  • (4162) Module Dimension fix: ignore empty override of dimension name,
  • (4152) Data Source/MSSQL PoSh fixes:  
    - Use double quotes for non-integrated security connection strings.
    - Remove $integratedSecurity -eq $false check in Import-MsSqlData method in 'Default Import Script'.
    - Avoid misleading 'Test Connection' result for PowerShell connections.
  • (4146) Data Source: more detailed log messages when using SSIS.
  • (4144) Tabular Module Definition fix for fact. Wrong subtype was set preventing processing.
 2. release   19. June 2020 Profitbase Studio 6.5 Build 4136
  • (4136) Data Source/Csv PoSh: Add Text Qualifier to file name ensuring support for column delimiters in file name.
  • (4135) Sub Dimension fix: Ensure that resulting map table with none dbo schema is deleted before re-generation.
  • (4134) Data Source/Csv PoSh: Support parallel execution when multiple tag values.
  • (4133) Auto update fix: Manual dimension editing triggers data change flag.
  • (4132) Data Source/Csv fix: multifile csv import failing with error "table already created".
  • (4131) Data Source/Csv PoSh: Support Space as Column Delimiter
  • (4121) Name Definitions: Add qualifiers to NameDefinitionID in Edit Column Post Expression (fixes bug where column namedef-Ids started with number)
  • (4120) Update: Auto update rewrite for better detection.
  • (4117) Fix: Added missing dll's for SQL 2017 SMO
  • (4109) Module/SSAS: Norwegian SSAS translation message handling for translation errors handled as warnings.
  • (4104) Data Source/PoSh: Add Support for Embedding Default Script in Excel and MS Access Data Source Connectors.
  • (4103) Data Flow: Fix Internal Data Source Table Ordering.
  • (4101) Data Source: PoSh script support for Excel/MS Access. Supports mdb, mde, accde, accdb, xlsx and xls.
 1. release   6. December 2019 Profitbase Studio 6.5 Build 4091
  • Internal build 3. January 2020, Build 4098 (available on request or at pbsndfile)
  • (4098) Module Fix: Module fact source view generation was skipped.
  • Internal build 12. December 2019, Build 4094 (available on request or at pbsndfile)
  • (4094) Fix SSIS Staging Tables support for Custom, Transdate and Incremental reloads. Staging table will now always be re-created. 
    --------------------------------------------------------------------------------
  • (4089) Added "Create DW database" link button to Module Target DW Connection tab.
  • (4087) P/C Dimension: Better processing error message.
  • (4085) Data Source: Clustered columnstore index support for reload without recreation of clustered columnstore index.
  • (4085) Data Source: Clustered columnstore index support for indexes and primary keys.
  • (4084) P/C Dimension fix: Validation of circular reference changed.
  • (4083) Server Login fix: Set to top to ensure not hidden behind the startup splash panel.
  • (4082) SSAS Tabular: Added options to add calculation group and to allow to paste more measure groups.
  • (4081) Support Auto Update Filter.
  • (4080) Support RELOADSOURCEFILTER tag in PoSh scripts.
  • 1.st release candidatate 6.5 Build 4079 (30 nov. 2019)
  • (4077) Add Create Dw Database function via link button in Target Dw Connection.
  • (4076) Auto Update fix: Ensure fact views are reloaded when source data changed to ensure updated distinct tables.
  • (4074) New! SQL 2019 Tabular: Added Calculation Group Table with templates for basic time function and some general functions.
  • (4072) Auto Update fix: problem where transdate reload was used even if it had been disabled in source table.
  • (4071) New! Auto Update: support auto update of dwh fact tables.
  • (4070) Data Source Staging table fix: bugs and added improvements,
  • (4067) New! Data Source: make Staging mode available in Add New Table wizard. Also put in table name as Name if name is empty.  Change in naming convention (_staging suffix removed).. Ensure support for all reload types.
  • (4064) SSAS Status fix: Status changed from MeasureGroup to status from its partition(s). This affects AutoProcess of measure groups to more correct result. 
  • (4063) Module/SSAS Validation: Allow two instances of the same dimension (role playing) to bind to same column if one of them is used as role playing dimension.
  • (4062) Template fix: DataSets and merge of Solution Templates to existing solution.
  • (4060) Data Source, Oracle PoSh fix: "Force Uniqueness" that failed using staging table instead of temp/mapping table.
  • (4057) Wide Dimension fix: Change PK column on Key Attribute change.
  • (4052) Data Source, MSSQL Custom PoSh for MSSQL fix: LinkedServer and SSIS fails or gives 0 rows.
  • (4051) SSAS fix: String comparison in general. Fixes case sensitive column/attribute name checks etc.
  • (4050) Dimension Modification Table fix: Change columns types by changes in name definitions (also key). Also, checks on column names are now case insensitive.
  • (4049) Wide Dimension fix: Corrected formatting of translation columns (as for name columns).
  • (4047) Module UI fix: Drag cell values in spreads (register row changes correctly, eg for checkboxes in Enable column).
  • (4042) Module: Added better resize and splitter to process dialog.
  • (4031) New!  Support for MS Sql 2019 and change from 6.4 to 6.5.

Profitbase Studio 6.4

 7. release   21. August 2019 Profitbase Studio 6.4 Build 4010
  • Internal build 21. October 2019, Build 4023 (available on request or at pbsndfile)
  • (4023) Fix SSAS: Where expression on splitted partition when using Current. 
  • Internal build 26. August 2019, Build 4012 (available on request or at pbsndfile)
  • (4012) Fix Data Source: Edit Table: Save failed for bool/bit columns. (revisited) Only worked for new rows not updates.
  • (4011) Disable "Create Default PowerShell Script" functionality for Excel data sources.
    --------------------------------------------------------------------------------
  • (4010) Studio Server: Timeout on job execution added. Default 10-hour timeout on executing jobs. If SQL server failures, 5-hour timeout. This is to avoid server being locked if using default job queue. Timeouts are adjusted in the server's configuration file.
  • (4009) Data Source: Use Az module instead of the deprecated AzureRm module when connecting to Azure Blob Storage.
  • (4008) Fix Job Schedule: Time format support for AM/PM.
  • (4007) SSAS: Add attribute translations to Apply Dimension Translation command.
  • (4006) Fix Data Source: Ensure that Stop Execution / Abort is working for PowerShell Data Source transfers.
  • (4005) Data Source:  Edit table fixes: Save of single quote + target dw connection not properly supported for PC/Dim tables.
  • (4004) SSAS Fix: Current partition where-expression on partition split was corrected.
  • (4002) Fix Csv Data Source via PoSh:  Import of file with only line break as column value failed.
  • (4001) SSAS: Consolidated error configuration and processing modes. Structure mode processing added for cube. Index removed.
  • (4000) Fix Csv Data Source via PoSh: Support for custom PoSh source scripts re-introduced.
  • (3999) Module DWH/SSAS: Enable/disable of module subgroups (cubes) and module definitions (measure groups). If disabled it will not be processed or added to SSAS.
  • (3998) Fix Excel Data Source: Import metadata failed if first worksheet was chart or image.
  • (3994) Improvement Csv Data Source via PoSh: Added data types and default values to Import function parameters.
  • (3993) Fix Csv Data Source via PoSh: Better handling of double quotes inside double quotes.
  • (3992) Improvement Csv Data Source via PoSh: Improved performance for CSV import via PoSh. 
  • (3991) Fix Data Source: Azure Blob Storage Csv: Support for fields missing text qualifiers.
  • (3990) Data Source: Staging tables support for Oracle and DB2 Linked server.
  • (3988) SSAS: New command: to apply level naming template (for P/C dimensions, default hierarchy).
 6. release  30. June 2019 Profitbase Studio 6.4 Build 3987
  • (3987) Fix for error introduced by fix #3974: Module DW command Process dimensions reloaded distinct tables resulting in poor performance.
  • (3986) Fix: P/C Dimension Level Names editing.
  • (3984) Data Source: "Create Default PowerShell Script" functionality not available for data warehouse sources.
  • (3983) Fix: Shared Calendar fixed year validation + include LastChanged and added Browse/Checkout menu in Navigator.
  • (3982) SSAS Multidimensional: Support for up to 3 partitions in Standard Edition (from 2012 and forward).
  • (3981) MSSQL Default Script: Removed $withpart parameter. User will need to handle collation conflicts within WITH statement himself.
  • (3980) Script: Embed Default Script fixes.
 5. release  3. June 2019 Profitbase Studio 6.4 Build 3979
  • (3978) Fix Data Flow: Support multiple levels of user folders containing both data source tables and folders.
  • (3976) Script: Support {{EmbedDefaultScript}} in data source context.
  • (3975) Object Naming: Added checks and updates to renaming of DWH objects in Solution Settings.
  • (3974) Fix Data Source: DWCONNECTION tag potentially pointed to wrong database when multiple solutions shared solution database.
  • (3973) Fix Data Source: Csv PoSh: Support filters.
  • (3972) Object Naming: Base object naming of User Folders added.
  • (3970) Fix Module Definition Dimension Usage: Open for more columns for fact tables to bind to dimension tables.
  • (3965) Fix Data Source: Edit Table to update distinct table values.
  • (3964) Fix Data Source Csv PoSh: Support multi line columns.
  • (3960) Fix New Data Source wizard: Test Connection failed for MSSQL PowerShell and SSIS connectors
  • (3957) Data Source: Add Support for Embedding Default Script in Data Source Connectors. (Csv and MSSQL supported)
  • (3953) Fix Name Definitions: corrected extraction of nvarchar/varchar length.
  • (3949) Fix Server: Remove alive timer event log messages + config file cleanup. 
  • (3931) Fix Data Source: Edit Table: Save failed for bool/bit columns.
  • (3928) Oracle Data Source: PoSh script failed with "Cannot bind parameter 'Path' to the target cannot find path "C:\Windows\System32\NugetPackages..."".
  • (3926) Fix Oracle Data Source: PoSh script failed because DataTypeName is not used by Oracle Provider.
  • (3924) Holiday calendars Year list extended.
  • (3919) Fix Data Source: Improved support for multi-level user folders as parents.
  • (3914) Fix Data Source: Azure Blob Storage Csv: Support for merging multiple files into one staging table.
  • (3913) Fix Data Source: Azure Blob Storage Csv: Improved preview support.
  • (3912) Fix Data Source: Support Ctrl+A->Ctrl+C in read-only forms.
  • (3908) Fix Tabular Modules: Extend expression field + enable columns on add new dimension tables.
  • (3905) Fix: Change on how solution databases are found in open solution dialog. Access is now checked before checking version.
  • (3904) Fix License Management: Correct deactivation of licenses.
  • (3896) Fix New Solution from template: Sometimes failed with "Unable to replace friendly name with physical table name"
  • (3895) Fix Module: Include deletion from Dataflow when deleted module dimensions are detected..
  • (3893) Fix: Sql connection settings when using sql user/password.
  • (3891) Fix: Ensure that selected user is used in Datawarehouse database creation.
  • (3883) Fix: Enable dwh user/password fields in new solution wizard.
  • (3882) Fix Data Source: Auto update for incremental table views.
  • (3881) Fix Module: Fact views with surrogate keys on sub dimensions.
  • (3880) Fix Data Source: Circular dependencies reported if deleted data source tables were scheduled for reload.
  • (3878) Scheduled jobs management: Splitter to allow resize added to UI.
  • (3876) Data Source Blob Storage DSC: Support for files directly in blob storage directory not using folders.
  • (3875) Message log: Reduce size on message IPSASM7020 (no xmla on ok).
  • (3871) Fix Autoupdate: Connection timeout from settings.
  • (3870) Data Source: Support WITH statement with OPTION (MAXRECURSIVE 1000).
  • (3869) Fix Dimensions: Errors when different properties in linked dimension mapping.
  • (3868) Fix: Set default connection timeout on opening solution to 120 sec.
  • (3867) Fix Module: Use of sub dimensions containing *Null/*Empty gave error when processing module definitions in DWH.
  • (3866) Fix Dimensions: Added circular reference check for Parent/Child dimensions on validate command.
  • (3865) Fix Dimensions: Rendering of parent/child dimensions for items with '.' and '-' in key. 
  • (3864) Fix Dimension: Include status from recreation of dimension result view. 
  • (3855) Fix Excel Data Source: Support for tags as worksheet names. Ensure all formats work.
  • (3854) Fix Dataflow: Data flow execution combined with i.e. manual processing often fails. Save of status changes updated.
  • (3851) Fix SSAS Linked Dimensions - fix multiple dimensions via same + binding to fact in via.
  • (3850) Fix Autoupdate Modules: On column changes etc. in the module definition, the modules view per fact source is also updated.
  • (3847) Data Source Table: Remove Hidden flag when changing from type "other" to "fact".
  • (3845) Data Flow Execute SSIS Package: If package fails; exit code = 1 is not sufficient information. Set "Finished executing DTExec.exe." to Information instead of Trace.
  • (3844) PoSh Data Source Table Timeout support
  • (3827) Adjustment Data Import: Better error handling. Split deserialization from bulk copy
  • (3826) Fix Sub Dimension: Added Schema on creation of mapping table.
  • (3820) Fix SSAS:  Corrected check of partition changes set by Data Source Tables. 
  • (3809) Fix SSAS: Ensure correct name for direct partitions.
  • (3808) Module DWH: fact result view is now using where clauses in union to help speed up queries by helping the query engine.
  • (3806) Data Source tables: "Skip auto update" support when updated from modules auto update.
  • (3799) UI: Change tab label "DW Connection Settings" to "Target DW Connection Settings" - applies to both data source and module.
  • (3794) Fix Data Source: Incremental staging tables for Oracle.
  • (3789) SSAS: removed XMLA command from log for message IPSASM7020. Used to much space in log.
  • (3777) Dataflow: Adjusting message log (parallel task show only selected commands + duplicate message id corrected).
  • (3764) Fix Data Source: Tag table/value missing message not displayed if tag is used in main filter
    + Also fixed lacking support for multiple tag values for same tag name and bad error message when saving empty tag value.
  • (3758) Fix SSAS Tabular: prevent hiding of columns to be overridden.
  • (3755) SSAS Partitioning: Show Process Partition menu also if direct partitions is in use. This was only shown when regular partitioning was in use.
  • (3750) Fix SSAS Tabular: display of formulas showed format (#D;#A; correctly replacing cr + lf in xml object).
  • (3743) Fix SSAS Action: avoid MeasureGroupMeasures wrapping in Target.
  • (3723) Fix SSAS Role script: Run script extension for roles and permission script on Delete and Create SSAS db.
 4. release  28. November 2018 Profitbase Studio 6.4 Build 3717
  • (3717) Staging table issues: SSIS, PK, Index, Maintain Modified Date, Maintain RecordID now supported.
  • (3702) Fix SSAS: prevent visible password in message log showing connection string.
  • (3694) Data Source:  Support browsing contents in Table Storage, Blob Storage and Data Lake Store
  • (3692) Fix Export: Azure Blob Storage export failed for NULL valued columns and int, decimal and datetime columns.
  • (3691) Fix Data Source: Delete Filter containing DWCONNECTION failed.
  • (3690) Data Source/Script - Open In Visual Studio Code: friendly name, macro and tag replacement.
  • (3685) SSAS Tabular: Support for translations of Name and Description (model, tables and columns).
  • (3678) Fix SSAS/Module Definition: BI validation to avoid NA-item.
  • (3677) Fix SSAS Tabular conversion: Enable/Disable columns/calculations:
    + Formula formatting preservers new line/tab.
    + Duplicate columns (bi vs fact) that resulted in paste error and instability was fixed.
    + Description from BI preserved.
  • (3673) Data Source: Support Azure Table Storage as Data Source via PowerShell.
  • (3670) SSAS Tabular: Update measure calculations.
  • (3665) Dataflow: Copy/Paste and Enable/Disable batch steps.
  • (3663) Fix Server: Correct Application Insight key name in config. file. Change from ApplicationInsightKey to ServerInsightKey.
  • (3641) Fix: SQL Expression builder: Execute of SQL updated data viewer in all open editors. Introduced instance flag to ensure only relevant editor is updated.
    + Moved Staging table check box to top Z-Order to ensure better GUI in 150 % zoom.
  • (3640) Fix Time Dimension: Ensure correct attribute sort. By key for weekday and month.
  • (3636) Fix PowerShell: first time failure of MSSQL PoSh. Changed LoadWithPartialName Microsoft.SqlServer.Management.Common to Add-TypeMicrosoft.SqlServer.ConnectionInfo.
  • (3635) New PFS 60.008.002: Metadata added for MS SQL PowerShell connection template.
  • (3634) Fix Dimension Processing: Validation of data removed from regular processing (3587). This took to long on wide dimensions. Checkbox added for manual processing.
  • (3633) Fix: Tabular conversion from measure group included error check. Also added check when removing dimensions from module group.
  • (3631) Fix: Version check on Azure SQL servers changed to compatibility level.
  • (3628) Data Source Table: Support View SQL Expression for PowerShell sources.
  • (3626) Fix: Wide Member Scan with SKey and different Value column (not the natural key).
  • (3620) Profitbase Studio Server installer handles override names in installation/registration.
  • (3617) Fix Versioned Dimension: corrections on add to avoid errors in processing.
  • (3614) Fix PowerShell: Fix column lookup and performance for MSSQL PowerShell.
  • (3606) Data Source SSIS: Support changing from SQL Server Destination to OLEDB Destination Adapter for all data source tables.
  • (3602) Fix Data Source: Fill and save of OLEDB and SQL Server Destination setting for SSIS connection method.
  • (3599) MSSQL PowerShell: Support for multi value tags i.e. COMPANYID (i.e. Dynamics AX and NAV).
  • (3587) Dimensions - validation of invalid parents and duplicates added.
  • (3585) PowerShell: tag should support SQL 2017.
  • (3554) MSSQL PowerShell: Support for filter and reload options.
  • (3551) Update Column Definitions: Support for dim tree and other DW data objects.
 3. release  2. October 2018 Profitbase Studio 6.4 Build 3546
  • (3545) Dimensions/Modules: Support for Surrogate Keys on P/C 2 Wide and Sub Dimensions (not P/C Sub 2 Wide).
  • (3544) Fix: Processing status - Reload Source Data data flow job fails if no tables when executed via server. Result changed from error to warning if config is missing.
  • (3540) Data Source Target dw db - Ensure data warehouse db drop down works for source types other than MSSQL
  • (3538) Data Source - Change of Table prefix to optionally change SQL expressions using old table prefix.
  • (3534) New PFS 60.008.001 - data changes only. Upgrade to ensure correct name definitions.
  • (3532) Data Source - Support connecting external data sources in Azure via PowerShell
  • (3531) Fix: Template - Save Connection Maps and dependent connection correctly.
  • (3530) Module - Enable mapping of PowerShell scripts against SSAS operations (before/after create/update dimensions, cubes, measure groups etc.).
  • (3529) Fix: Module P/C Dimension - Update attribute names when renamed in module to avoid default member problems.
  • (3528) Azure and PFS (create and upgrade solution database in Azure)
  • (3526) Added horizontal scrollbar and word wrap menu item to rich text box mainly used as Edit Comments form control.
  • (3525) Improve performance on load of solutions with many data source tables
  • (3524) Refresh: Refresh Entity Framework from database
  • (3521/3522) Avoid "Browse for servers" dialog on first time startup of Studio. Validate that server name is not empty.
  • (3518) Avoid using sp_helpdb, use sp_databases instead as this performs better
  • (3517) DW Split Fix: Connection timeout + double view registration.
  • (3516) Data Source Table Delete Data: Update Parent Statuses.
  • (3513) Data Source Table User Folders: Sub folders for tables.
  • (3512) Fix: Generate Type folders adds tables using ascending sorting, resulted in strange execution sequence in data flow.
  • (3511) Fix: Added Wait cursors for non-responding GUI when adding new data flow for Load/Update Solution Data.
 2. release  13. September 2018 Profitbase Studio 6.4 Build 3510
  • (3508) Fix: Module Wide Dimension - Setting correct default value for boolean attributes.
  • (3506) Removed support for integrated tables. This functionality was introduced in 6.3 and is discontinued partially because now staging tables have taken its place.
  • (3503) Fix on Dimensions, Sub Dimensions and Module Dimensions: Surrogate key handling in dimension and module scan handling.
  • (3502) Fix Module: Update status on single dimension processing.
  • (3499) Change Data Source: Hide integration modes for dw source data and table types different from other and fact.
  • (3498) Data Source: Support adding multiple Staging and Linked tables from metadata table GUI.
  • (3492) Fix Sub Dimension: Validation and cleanup of consistency in user selected items (when source dimension changes). Implemented in UI, not in processing.
  • (3491) Auto update: For modules, content with errors is included in processing.
  • (3486) Data Source: Improved performance for lookup of distinct table column metadata.
  • (3485) Fix on New DWH database (solution) - rewrite of copy and status check.
  • (3484) Fix Data Source: Parent/Child dimension table using SKey failed.
  • (3483) Fix Data Source: Oracle Field Metadata failed: After upgrade field metadata SQL contained and TABLE_NAME LIKE ''.
  • (3481) Fix on Upgrade: New naming model failed for internal data warehouse SQLs. 
  • (3477) Data Source: Support linking External data. Support for adding these as execute script data flow commands. 
  • (3474) Visible status update on processing (e.g. client shows symbols for processing when server runs dataflows).
  • (3474) Fix: App.insights step in dataflow logs also if license is missing.
  • (3458) CSV file import: PoSh to support | as column delimiter and " as text qualifier.
 1. release  26. August 2018 Profitbase Studio 6.4 Build 3455
  • (3452) Data Source: Import CSV from Azure Data Lake Store and Azure Blob Storage.
  • (3446) Update module group dwh status when processing (single) dimensions.
  • (3445) Wide Dim Member Scan - check on column length on insert.
  • (3438) Status Override Commands for Dataflows.
  • (3435) Support for dBase via custom SSIS connection string.
  • (3434) Application Insight - Heartbeat
  • (3433) Tabular fixes.
  • (3431) Improve performance and visibility of mapping tooltips.
  • (3430) Data Source Staging Table: Incremental and Transdate Reload support.
  • (3406) Staging tables support for specifying PKs (and indexes).
  • (3400) Parent/Child Dim Source: Auto Update.
  • (3399) Auto Update: Data Source Tables auto loaded if config changed and if table/view does not exist.
  • (3398) File PowerShell: Try catch around Open StreamReader to avoid continued execution.
  • (3397) Text editor: Back color change to indicate all instances of selected word.
  • (3393) Support separate data warehouse connection for metadata tables.
  • (3390) Access control added to copy/save as template.
  • (3387) "Create default script" option for Export scripts.
  • (3387) Support Timeout in SELECT COUNT(*) statements.
  • (3384) Search dialog (F3) is extended with scripts and general content names.
  • (3369) Beta to Release Candidate (RC).
  • (3368) P/C Sub Dimension Fix: To Wide if more than 9 levels deep.
  • (3357) P/C Dimensions Fix: Check and opt. change data types in modification tables according to NameDefinitions.
  • (3354) License Fix: File license id was case sensitive,
  • (3353) Tabular SSAS: add dim columns + format on create..
  • (3348) Fixed: Paste of Dimension Mod Table
  • (3341) Data Source Table Column Mapping: Implemented Sort By Category 
  • (3337) SQL Agent Jobs: Fixed GoTo on Error between dataflows.
  • (3312) Module: Changed Measure Association to Measure Group only (UI BI checkbox default off)
  • (3308) Data Source: Removed Db2 PoSh option
  • (3307) Data viewer: support float and real data types when using Edit Table in all environments.
  • (3306) PC Dimension Editing: Refresh SC changes.
  • (3304) PC Dimension Editing: Formatting of properties in item editing
  • (3300) Slowly Changing: SCDFromDate from source support
  • (3298) Slowly Changing: Improved SC PC Dim editing + PC Dim Source Table loading
  • (3294) Data Source: Improved defaults for date ReloadValue expressions (CONVERT(varchar, date, 121)).
  • (3293) Data Source: Oracle PoSh support
  • (3292) P/C Dimension Fix: Different casing on Properties fixed. Casing ignored and filling of property drop down and dim.processing with values from source should now work.
  • (3266) CSV: Improved defaults for code page (UTF-8) and Locale (CurrentCulture)
  • (3265) CSV FILE via SSIS support for overriding connection string (i.e. use ACE instead of Jet in 64-bit environment)
  • (3258) Export: Improved support for Azure SQL Database 
  • (3254) Tabular SSAS: Support for Cross Filtering Behavior + Fix delete of db
  • (3253) Tabular SSAS: Fix initial settings, sort column, hierarchies and change between PC to PC2W. 
  • (3250) Export: Add script extension support
  • (3246) Data Source Staging Tables: Support for Custom Reload
  • (3244) Module Processing dialog: Option to skip validation.
  • (3243) Data Source Staging Tables: Allow for RecordID and Modified Date maintenance
  • (3236) History: Ability to load more than 100 rows of historic data logs
  • (3233) Solution Status: Remove rightmost solution status as this is redundant/slow and error prone.
    Note! This significantly speeds up first time load of solution GUI as well!
  • (3232) Solution Placeholder Tags: Support in Data Source Table definitions
  • (3229) Excel Source: Add Row number as column + change column names for non-SSIS Excel to F + column sequence instead of Column1, Column2 etc.
  • (3227) Support for 32-bit execution of SSIS source tables.
  • (3225) Support for no header rows and sheet tags for non-SSIS Excel data sources.
  • (3218) Excel Data Source: Support tags for worksheet names.
  • (3218) Allow for Save of SSIS Package if 64-bit SSIS.
  • (3214) Process multiple of the Modules main commands (DWH/SSAS).
  • (3213) Allow override of SSAS DB ID. Restored copies of same module can create new SSAS databases. 
  • (3210) Module Definition to Tabular conversion through paste.
  • (3209) Fix SSAS Action: Remove default 'All cells' for URL Actions on Cell.
  • (3206) PFS fix: P/C dim level hidden + enabled set on upgrade for null values.
  • (3205) Fix Data Flow: Save of new data flow steps fails if conditions exist.
  • (3204) Data Flow Data Source Tables: Tag Values loaded after PC Dim Tables. 
  • (3200) Script and Export: Support Access Control - hide items with restricted read permissions.
  • (3197) Export: Added Export Scripts to export script(s) data flow job.
  • (3192) Export to CSV, Azure SQL Database, Azure Data Lake Store and Azure Blob Storage.
  • (3192) Improved error messages if EF Save fails. 
  • (3190) Validate missing BI item. Better error messages.
  • (3189) Fix: Save dim items from scan.
  • (3161) Fix: Corrected error while running module script extensions.
  • (3159) Support indexes and Primary Keys for columnstore indexed tables (SQL 2016+).
  • (3154) Azure DB + Azure Analysis Server adjustments. Tabular models in Azure can be created, Username + Password added for SSAS connection.
  • (3149) Support for staging tables - no need for name definitions etc..
  • (3148) Fix:  Better handling of rare case of timeout after ten minutes during distinct scan of views when using data warehouse source.
  • (3144) Fix: Ensure SQL Server login is supported when executing data flow from client.
  • (3143) Fix: First time server selection.
  • (3141, 3145) Improved Azure SQL Database support.
  • (3140) Fix: Better error messages on start/end of processing.

Profitbase Studio 6.3

 3. release  9. March 2018 Profitbase Studio 6.3 Build 3133
  • (3133) SSAS: AutoProcess -> from Trace to information to preserve history.
  • (3132) SSAS Create/Update dimension revisioned. Less demand for deleting before running create/update for existing dimensions. More checks to avoid errors in SSAS.
  • (3131) Script: Comment/UnComment functionality in Expression Text Box (\n instead of Environment.Newline
  • (3130) SQL Expression Builder: Find dialog has no parent form if PowerShell, also Open in Visual Studio Code failed.
    + Also Created ReloadValueTagTable if Edit was clicked.
    + Improved PoSh implementation for timeout and error details.
  • (3128) Wide Dimension: support for Parent attribute type so that wide editing can be used to create Parent/Child dimensions.
  • (3127) Concurrency: Fix on error/behavior on new content added.
  • (3126) Module: Fix module command text for lang text to meta data.
  • (3125) P/C Dimension Edit: Error handling in update of properties,
  • (3124) Wide Dimension Edit; Speed up and added expand/collapse hierarchy tree.
  • (3123) Skey to NKey or NKey to SKey Processing: Data Warehouse Source Tables not updated correctly.
  • (3122) SQL Expression Builder: Update Column Definitions did not add newly added columns if ItemID was present in column list.
  • (3121) Skey: Data Warehouse Source Tables updated correctly.
  •  
  • Internal build 22. February 2018, Build 3113
  • (3113) SSAS: Dimension Attribute Value column set as key if no other definition exists. Better usage in PowerBI reports agains SSAS MD.
  • (3112) Module validation: Remove warning WPSMCVAL424 - On both def.member  and all level.
  • (3111) UI: Sort data source columns by name.
  • (3110) Fix: Sim export UI - drop down filling fixed.
  • (3109) Data Source: Ensure consistent sorting for data sources.
  • (3108) User folders: Support for user folders to group data sources.
  • (3107) Fix: Access check on start page w/info cards.
  • (3106) Fix: Concurrency: Prevent multiple messages on processing.
  • (3103) Comment/Un-comment functionality in Expression Text Box (e.g.scripts, data source mapping).
  • (3102) Check length of table/view names.
  • (3101) DW Upgrade with new option to chose naming model.
  • (3099) Template management: Improve performance for XML editor/viewer.
  • (3098) Data viewers: Set MSSQL as default syntax highlighting.
  • (3097) Fix: Data Source: Data Warehouse sources does not take row limit into account in preview.
  • (3096) Fix:  Data Source Table: P/C tables missing DataSourceID and SolutionID in view. Now reflected in dwh drag drop. Also fixed save check were ItemID was also ParentItemID.
  • (3095) Fix: User Folder in Data Flow context: null referece when trying to change name in GUI.
  • (3092) Fix: Set ModuleType correctly for WebPlan modules.
  • (3091) Fix: Memberscan for SKEY. Wrong name used for SKEY stat table.
  • (3089) Fix: Script extension for dimension null fix.
  • (3084) Fix: SSAS, default provider set to sqlncli11 (except sql2008)
  • (3080) Fix: SSAS, delete many-to-many dimension
  • (3079) Fix: SSAS, additional settings for multiple data sources and data source views.
  • Internal Build 25. January 2018, Build 3076.
  • (3073) UI: Better marking for developer/test mode. Yellow marking moved to menu bar at top.
  • (3072) Fix: SSAS AutoProcess - adjusted after reported error (ref. 3043).
  • Internal Build 23. January 2018 Build 3062
  • (3061) Fix: Corrected selection of SSAS DataSource if multiple existed.
  • (3059) Fix: Avoid login failed when adding new items if SQL Server login user.
  • (3056) Fix: truncated inserts from scan and update of dimension mod. tables.
  • (3055) UI: Script extension mapping for module - hide/show settings.
  • (3053) Fix: Autoupdate of dimensions due to distinct tables used in scan.
  • (3047) Fix: Status viewer refreshed after status override.
  • (3045) UI Scheduled Tasks made horisontally adjustable.
  • (3044) Fix: Paste dataflows. Duplicate source items removed.
  • Internal build 9. January 2018 Build 3043
  • (3043) SSAS AutoProcess - Extra check on fact after dim processing.
  • (3042) Fix of solution merge from template w/partial solution items + removal of sys.folders 
  • (3040) Allow for editing owner on SQL Server Agent Jobs
 2. release  22. December 2017 Profitbase Studio 6.3 Build 3037
  • (3033,3026, 3023) Support for using ItemID/ParentItemID + SKey in Data Source Table and Dimensions.
  • (3032) Trim space from server and database name from configuration files. Prevents 'change dw database' to show on start.
  • (3029) Improved performance for loading Table objects in script editor and SQL expression editors.
  • (3027) Data Source: SQL Expression Builder; make views available for internal source drag drop. Make it default type for Parent/Child Tables.
  • (3024) Added null checks to avoid null pointer exception on "Show documentation" for Data Sources.
  • (3021) Prevent that navigator expands all nodes when editing user folders.
  • (3020) Fixed member/reduce scan on referenced dimensions.
  • Internal build 18. December 2017 Build 3019
  • (3019) Templates: Selection of parent nodes for solution.
  • (3018) SQL Expression Builder; made views available for internal sources via Change Table Reference.
  • (3017, 3016) Processing after changing to Surrogate key now automatically handles internal source tables.
  • (3015) Dw connection fix for module (dw callback vs target) 
  • (3015) Corrected P/C dim property casing (e.g. Fontsize vs FontSize) causing processing error.
  • (3014) Front page error message on start.
  • (3013) Specify that SSAS callback connection is using SQL server UserName and Password.
  • (3012) Disable "Clear log" function while processing.
  • (3011) Fix on Delete - null check for Dimensions ++
  • (3010) Backup Database: Fixed Browse button enable/disable mismatch bug introduced in 6.3.
  • (3009) Partitioning: Multiple Target DW Connections support.
  • (3007) Fixed: Add New From Local template store fails because of missing null check.
  • (3004) Status History: Show most relevant fields leftmost. Introduced Name in place of ContentID as well.
  • (3003) Fixed missing virtualization of WPF TreeViews slowing down GUI.
  • (3001) Fixed: Incremental Table scripts were created with Fact as SubType. 
  • (3000) SQL Expression Builder: Dragdrop of Parent/Child tables now have view as default.
  • (2999) Copy/Paste/Template for TargetConnection + SolutionMetaData + Enable dw terget connection in module.
  • (2998) Fix: Process module header + '_' support.
  • (2993) Data Flow: Added Support for Parallel execution of other commands than Reload Data Source Tables, namely Generate Dimensions, Module Command(s), SSAS Command(s) and Execute Script(s).
  • (2993) Dim Tree: "Process" and "Tasks and Data" as separate buttons instead of dropdownmenu buttons. + Separator only visible if "Edit Settings" button is visible.
  • (2993) Process Dim: Skip validation if Auto Update.
  • (2993) Enable Abort Processing for Scripts.
  • (2993) Module/SSAS Tasks: Filter on SolutionID in Module Group drop down list.
  • (2992) Fix on module fact source view - TinyInt had cast to -1 if null. Now set to 0. (0-255)
  • (2991) Show "Rebuild index" form in front of parent form.
 1. release  22. November 2017 Profitbase Studio 6.3 Build 2990
Final release after Beta and RC program. Expanding on What's New; the following features and fixes are included:

New features:
  • Parent/child and wide dimension surrogate key editing.
  • Wide dimensions: Force uniqueness functionality for attributes and hierarchies. 
  • Versioned dimensions.
  • Search dialog.
  • Concurrency support.
  • Separate target data warehouse connections for Data Sources and Modules.
  • Integrated Tables.
  • Test/Production mode w/todo list.
  • MS SQL 2017 
    • support (tabular comp.1400). 
    • Partitioning: Allow Enterprise storage options in Standard edition for SQL2016 SP1 and SQL2017
  • Application Insights logging.
  • Support editing scripts in MS Visual Studio Code/SSMS (intellisense supporting tools) and handle object names and tags automatically.
  • Coloring and line numbering in script and expression editors.
  • Scripts embedded into other scripts.

Fixes:
  • (2988) P/C Dimension: Fix Import of P/C dimension level - Row selector now works.
  • (2986) Data Source, SQL Expression Builder: Fixed update of Column Definitions for internal tables after upgrade
  • (2981) Access: Hide items not executable because of access control settings.
  • (2979) SSAS Action - include fact dimension + edit + Target=MeasureGroupMeasures(mg name).
  • (2974) SSAS: Default error settings on process button changed from ReportAndContinue to IgnoreError
  • (2971) Module: Enabled flag set on fact source column if BI column is disabled. BI overrides fact.
  • (2970) Dimension: Sort Dim Source By Rank + UI sort support.
  • (2961) Data Source: Support for drag drop of friendly names in SQL expression builder filter field.
  • (2956/2957) Dataflow - Fixed adding new Incremental Dataflow.
  • (2955) Module/SSAS: Xmla Process Current in parallel + Dax formula scrollbars.
  • (2949) Avoid version 2.0 of PowerShell being the cause of failing "Abort" for Data Source and Script Processing.
  • (2948) Incremental update dataflow and Process Add task fixed.
  • (2918) Linked server "Server list" drop down performance problem fixed.
  • (2912) Expand navigator to show selection.
  • (2909) Include in copy with headers from data browser.
  • (2908) Better display name in visualizer.
  • (2879) Fix connections for SSAS 2016
  • (2871) Ensure Filter does not fail when replacing tags.
  • (2863) Access Control: Avoid showing non- accessible objects in all other contexts than navigator + Copy/Paste support.
  • (2862) Data Source: Tag Tables to properly support "Generate as view"
  • (2860) Data Source: DB2 Test Connection did not add OpenQuery syntax to SQL being executed.
  • (2859) Module: Load SSAS Cube Error Settings.
  • (2856) User Folders: Sort Index equal when sorting Ascending + Avoid drag drop of scripts into non- Script Extensions folders.
  • (2846) SSAS: KeyDuplicate default changed to ignore.
  • (2843) Description_nn not included if not in solution language texts. Warning given. Will not work with PC2W.
  • (2842) Data Source: Fix friendly names for distinct tables in script macros + Expand errors and warnings in log.
  • (2826) Data Source Table: Generate As View checked while disabled.
  • (2823) Data Source Replaced Preview Table drop down menu with button.
  • (2810) Import of PC level fixed.
 

 

Profitbase Studio 6.2

 Internal build Internal build 6. October 2017 Build 2897
  • (2883,2897) Fixed handling when licenses expires in server + fix in Server Management UI.
 9. release  4. September 2017 Profitbase Studio 6.2 Build 2848
  • (2848) Data Source Transfer: Improved handling of rare case where temp table row count failed.
  • Internal build 23.August 2017 - Build 2839
  • (2838) Script Extension: Fix friendly names for distinct tables in script macros
  • (2835) Visualizer fixes for image and placement.
  • (2833) Modules: Changed from warning to trace message for dimension usage with different key binding.
  • (2832) Modules: Update of dependency view for modules. Upgrade of database required.
  • (2830) SSAS: Fixed auto process of measure groups.
  • (2829) Dependency viewer: Show direct dependencies expanded as default. Introduced Recursive button.
  • (2828) Data Source: Dependencies not saved on upgrade.
  • Internal build 8.August 2017 - Build 2818
  • (2818) Dimension editing: Fixed error in dimension tree mapping.
  • (2765) Fixed license check.
  • Internal build 24.may 2017 build 2752
  • (2752) Fixed license check.
  • (2710) Edit Table Name: Failed with null pointer exception if Main Filter was not set.
  • Internal build 18.April 2017 - Build 2660
  • (2660) Fixed corrected SSAS db name on paste or when adding from template.
  • (2659) Disable add new solution from local template when no existing solution db is set.
  • (2658) Update lang.texts in P/C dimension modification tables on processing in dim.layer,
  • (2657) Added performance improvement comments if csv text qualifiers are used in PoSh Data source.
  • (2656) P/C dimension Description also set to other language text when from fact. Modification type changed from F to C on edit.
  • (2654) Data Source Table PoSh: Preview source table did not replace tag values.
 8. release  31. March 2017 Profitbase Studio 6.2. Build 2647
  • (2646) Rename DW table/view fixes.
  • (2638) SSAS Translations - hierarchies/levels.
  • (2636,2642,2647) Change DW Table Name in Properties dialog:
       - Do not hide or disable Update...-button when no DW items exist.
       - Change to content properties for base object name check.
       - Don't allow changing DW table name without updating dependants.
  • (2631,2632) Server license check moved to per job and not per loop.
  • Internal build 16. March 2017
  • (2625) Changed format of duration in status messages to better support 12-hour time format.
  • (2624) Data Source Table Preview mapping: Always support for removing and re-entering row limit.
  • (2623) Data Source: Introduced button "Load status" to trigger load of Data Source Table status.
  • (2622) Improved Used By dialog. Larger form w/ expanded nodes showing only direct usage.
  • (2620) Ensure Data Source status is updated if item inside user folder was processed.
  • Internal build 13. March 2017
  • (2611,2612) Auto Update fixes (no reload of sources w/error + texts, branch, sync).
  • (2610) Improved performance for AD Import of Users and groups.
  • (2608) Access Control: Dw and script expression implementation to hide deny-read objects.
  • (2605) Timeout changed in 'Change DW DB' wizard.
  • (2603) Dimension Usage enable clean up (no ref. to module parts enable).
  • (2599) Fix on Parent/Child dimensions reduce scan. Parents not removed for *Null and ** not removed for sub dimension
  • Internal build 9. March 2017
  • (2596) Fix on code and message for invalid SSAS settings. 
  • (2595) Fix of Auto Process Module Definition task. Wrong index for dimensions.
  • (2594) Remove the 'none critical' error message from PB Server log.
  • (2592) Fix for Data Source Tables. Set primary key columns not nullable before inserting data.
 7. release  24. February 2017 Profitbase Studio 6.2 Build 2576
  • (2576) Status update in navigator and operation log from (auto) processing of SSAS. Also applies to other processing tasks.
  • (2570) Undo task 2556. P/C dimension includes UnaryOperator and MemberFormula if module DWH dimension has values in these columns (not null or blank).
  • (2569) SSAS Unknown handling for type None added.
  • Internal build 14. Feb. 2017 (removed).
  • (2557) Fixes for Access Control. Creator will be admin. If not in user list/registered, no access is given.
  • (2556) P/C dimension now always includes UnaryOperator and MemberFormula.
  • Internal build 9. Feb. 2017
  • (2549) Added new feature to edit existing SSAS/Module DWH commands in the Process dialog and dataflow step editing.
  • (2547) Sub dimension mapping in module definitions fixed.
  • (2546) Fixes null reference errors on 'new from template'. 
  • (2544) Navigator fixed for hang and stack overflow.
  • (2543) Names of dimensions, cubes and measure groups are now trimmed for space.
  • (2541) Advanced SSAS cubes settings for SQL 2016 installation now showing again. Should only be disabled for tabular models. 
  • Internal build 26. Jan. 2017
  • (2496) Sort type changed from Name to Key on WeekDayNo attribute (attr. related to day, not WeekDay which already was key).
  • (2495) New SSAS cube dimension settings added to dimension usage dialog to control how member and hierarchy names are handled. 
  • (2494) SSAS cube dimension fixes on visibility. Regular and time dimensions can be hidden (at cube level).
  • Internal build 23. Jan. 2017
  • (2486) Server license check fixed.
 6. release  14. January 2017 Profitbase Studio 6.2 Build 2473
  • (2473) XML PoSh data source: Ensured column value over 1000 characters gets cut; avoiding truncate error in WriteToServer operation.
  • (2472) Improved handling of "Execution timeout expired" error message while updating null/empty values.
  • (2470) Module status checks added when running Auto update processing.
  • (2469) Fixed error in P/C dimension processing.
  • (2468) Fixes to avoid errors with 'Dispatcher processing has been suspended..' when dialogs are displayed.
  • (2467) Implemented Stop/Abort for Script Extentions.
  • (2466) XML and JSON PoSh data sources: Implemented Source Metadata Columns lookup functionality.
  • (2465) Added automatic vertical scrollbar when using "Load All Solution Scripts" in "Add Script Extension" GUI.
  • (2464) XML PoSh data source: Handle large xml files better by using less resource demanding xml file reader.
  • (2463) Excel data source: Skip SSIS option now handle duplicate column names by adding counter as suffix.
  • (2462) Solution Partitions: Improved "Split into many" default settings when RIGHT is set as Left Range.
  • (2461) Fixes in server and stored procedure called by SQL Agent to avoid error message caused by failing PB server alive check. If SQL or PB server is busy, it sometimes do not reply within the 2 minute timespan used in stored procedure CmdSrvTask_ExecDF in database PBMSSRVDBV6. This must be manually updated if this database already exists. See known issues.
  • (2461) Fixes in upgrade of Time dimension.
  • (2449) Fixes in upgrade of data types and name definitions. Also turns of member scan with module dimensions using nnnReportID.
  • (2447) Fixed error when adding new Wide Dimension.
 5. release  15. December 2016 Profitbase Studio 6.2 Build 2415
  • (2415) Sub Dimensions with *NULL and *EMPTY correctly mapped.
  • (2400) Fixed deletion of Module sub groups.
  • (2398) Improved performance when activating a data source table.
  • (2394) Wide dimension modification table fix. Columns got wrong datatype from views.
  • (2393, 2414) Tabular 2016 fixes - request account info on add model, auto add hierarchy, not Sum formula on bool/date/string. 
  • (2390) Wide Dimension fixed for removing translation and format dropdown text. Parent/Child properties regrouped with new 'from source' group and CompanyID added..
  • (2389) Script Extension issue: GUI is cleared if user right clicks in Navigator to Browse data.
  • (2387) Show Configuration Last Changed information in solution dimension keys overview.
  • (2386) Excel Data Source; backward compatible when skipping SSIS (using .Net): Handle single quotes surrounding worksheet names.
  • (2384) Transdate comparisons fixed for case insensitive. E.g. TransDate in stead of Transdate failed in Partitions.
  • (2383) Fixed missing columns UnaryOperator and MemberFormula when using Add From Template/Paste.
  • (2381) Upgrade: Ensure Dimension Keys backward compatibilty.
  • (2378) Password as *** for SSAS Data Source Settings.
  • (2377) Fix on entity frameworks POCO model to better handle nullable foreign keys in loading.
  • (2376) Parent/Child Transfer File SSIS problem: Table Filter not used.
  • (2375) Parent/Child Transfer SSIS-less Excel problem: Table Filter not used in data flow context.
  • (2374) Wide dimensions modification table checked for type and size changes in columns.
 4. Release  23. November 2016 Profitbase Studio 6.2 Build 2369
  • (2369) PoSh data sources: Parent Child DimSource Tables should support table filter.
  • (2368) Data Source: Handle upgrade better where DimensionID TAGValueID is in use.
  • (2367) Parent Child DimSource Tables for CSV PoSh files failed with missing temp table error message.
  • (2366) PoSh data source previews: Should take row limit into account. Done for JSON and CSV.
  • (2364) SMO-version lookup could go wrong if newer updates were installed.
  • (2363) CSV PoSh Data Source: Column headers not using text qualifier had first and last character trimmed.
  • (2362) Better support for text scaling.
  • (2361) Timedim level translation fix.
  • (2359) Excel Metadata: Error resulted in OK status.
  • (2357) Data Source: "View File" fails for http, ftp, https files.
  • (2353) Auto Update DW: Wide dims always selected w/ reason: "Source needs to be processed (and then this)"
  • (2351) Data Source: Timeout and row limit setting were not saved for File data sources.
  • (2350) P/C Dim Table Preview mappings failed for PoSh data sources.
  • (2350) Data Source: Support for https, not only http and ftp.
  • (2347) Add new DW source table: Limit of current data source tables is set to 1 instead of 2.
  • (2346) Data Source: Expand "Reload Settings" section if ANY reload options are used.
  • (2345) Excel Data Source: Only Skip SSIS option was available.
  • (2344) Copy/Paste of mappings fails for Parent Child tables and tables with PK or Index definitions.
  • (2342) Data Source Transfer: Keep Temp Table did not allow for browsing _Staging table after processing
  • (2342) Map Source Columns function should ignore identifier qualifiers ("[" and "]") when matching columns.
  • (2340) Create pbPlaceholderTagTable if it does not exist.
  • (2339) Incremental and custom reload options wrongly enabled/disabled in Reload Source Data data flow GUI.
  • (2338) Parent/Child Dim Tree: Deleting newly added Level Definition gave null pointer exception.
 3. release  27. October 2016 Profitbase Studio 6.2 Build 2335
  • (2335, 2332) Description fields in SSAS databases filled (also for translations).
  • (2334) Change of DW Object Names from the Property dialog now updates internal SQL and script expressions.
  • (2333, 2328-2331) Copy/Paste and Template fixes. Fixed editing of new items after paste/add from template did not work correctly. DW names correctly substituted in Copy of Script Extensions.
  • (2327) Navigator context menu fixed on what is shown and errors (properties, scripts, sol.config menu error).
  • (2323-2326) Added Refresh button to hierarchical log in "Operation and Message log" GUI. Removed unnecessary warnings in Dwdb upgrade log. Removed status image for script folders.
  • (2316) DWCONNECTION tag pointing to data source db and schema instead of DW connection.
  • (2312) "The ObjectContext instance has been disposed..." error when moving from a Surrogate key using SCD to a surrogate key not using SCD.
 2. release  18. October 2016 Profitbase Studio 6.2 Build 2311
  • (2311) Data Source Tag usage: Display if tags are used in script extensions. 
  • (2310) Data Source Table: Ensure "View source data" function uses current (potentially unsaved) file name setting if CSV data source.
  • (2309) Access Control: Adjusted to use enabled settings.
  • (2308) Dimension: Change from fact to user modification if user changes a dimension items parent.
  • (2307) Data Source: Remove Header row detailed settings as they are presently not directly supported in CSV sources using PowerShell.
  • (2306) Tag context: Removed CSV specific tags from tag list where not applicable.
  • (2305) Tag support: Fixed bugs for the COLUMNDELIMITER and ROWDELIMITER tags.
 1. release  14. October 2016 Profitbase Studio 6.2 Build 2304

Final release after Beta and RC program. In addition to What's New; the following fixes and features are included:

  • (1862,1881) Log: Duration time in logs. Added in more logs and fixed display formats.
  • (1909) Log: Better performance on where clause in log viewer queries.
  • (1909) Data Source: Disabled unused buttons when table is in edit mode.
  • (1909) Data Source: Fixed editing of Multiple Value Tags.
  • (1947) Data Source: Reload Source Tables showed reload options that should have been disabled.
  • (1947, 1991) Data Source/Module: Distinct scan fails if solution upgraded from 6.0 "Missing column [Created]" error message.
  • (1962) Data Source: Ensure SSIS folders are created if lookup on default instance of SQL Server (Machine name) goes into a "login timeout expired.." exception.
  • (1963) Data Source: Avoid empty table names in ProfitbaseAuto SSIS catalog.
  • (1969) Data Source: Ensure Oracle Functions does not show up for Excel Data Sources.
  • (1970) Distinct scan failed if solution upgraded from 6.0; "Missing column "Created"" error message.
  • (1991) Data Source: Softer Reload mechanism added when the user changes a surrogate key into a slowly changing dimension.
  • (2120) Script Extensions: Implemented Search/Find (right click) for Sql scripts.
  • (2120) Data Source: Change from Incremental to Date reload without removing table first.
  • (2145) Fix of "Dispatcher processing has been suspended, but messages are still being processed". Errors will still come, but less frequent.  
  • (2158) Data Flow: Statement Timeout for SQL scripts fixed (was 10 min.).
  • (2168) Time Dimension: Fixed Fiscal/Trade format and fiscal hierarchies enabling fixed.
  • (2170) Dimension: Unknown dimension item text changed.
  • (2191) Dimension: Editing wide dimensions on source change. Validation before process (relations and hierarchies required now). Div. UI fixes.
  • (2194) Module: Validation of BL Fact Measure fixed.
  • (2195) Module: Sim export fixed.
  • (2201) Module: Sync columns fixed. System columns (DataSourceID, FactSourceTableID) are not removed.
  • (2205) Module/SSAS: Null Processing Option and Invalid XML Characters is added to Advanced SSAS Settings for Measure Groups.
  • (2213) Dimension: Wide dimensions editing of hierarchies fixed.
  • (2222) Dimension: Wide dimension attribute translation columns for name handling are fixed.
  • (2225) Data Source: Improved support for using script extensions to load source data.
  • (2227) Data Source: Enable "Update Tag Value" button if "Reload Value" tag is selected.
  • (2231) Time Dimension/Module: Better detection of changes used in Auto Update.
  • (2233) Fixed Solution language text editing.
  • (2236) Fixed New Name Definition dialog. Default data type and more.
  • (2240) Module: Ask to add new columns in Module Definition/Measure Group when a new source is added.
  • (2242) Module/SSAS: Select All Partitions right click menu added for partition list when selecting "Process specific partition(s)" from the processing dialog.
  • (2254) Module: Names of Module DW commands changed and better tooltip for SSAS Delete and Rebuild w/Process command.
  • (2262,2264,2266) Access Control fixed (e.g. no editing when Read Only).
  • (2272) Module: Fixed Auto Update of module DW. Result views were not created/registered correctly in earlier versions.
  • (2275) Data Source: Connection types sorted when adding new Data Source.
  • (2279) Module: Fixed scan of system column DataSourceID.
  • (2280) Add server connection dialog fixed.
  • (2281) Dimension: Handles editing of P/C dimension items with ' and other symbols in the ItemID.
  • (2282) Data Source: Better logging of errors when staging tables is missing.
  • (2283) Upgrade/Dimension: Added checks for null and duplicates. PK added. Sub dimension user selection tables fixed.
  • (2289) Dimension: Dialog for P/C Dimension item and property value mapping fixed. Wide dimension check for duplicates fixed. 
  • (2292) Data Source: Edit Table option to Add New dialog added.
  • (2293) Data Source: Set editable tables to be internal source if DW source.
  • (2300) Module: Delete of modules w/script fixed.
  • (2302) Copy w/unselected sub content fixed. 

Profitbase Studio 6.1

 1. release  7. July 2016 Profitbase Studio 6.1 Build 1859
  •  Final release after Beta and RC program. Upgrade older 6.1 versions to latest..

Profitbase Studio 6.0

 1. release  11. November 2015 Profitbase Studio 6.0 Build 5737
  •  First release after Beta and RC program.
 2. release  18. December 2015 Profitbase Studio 6.0 Build 5820
  • (5786/4.Dec.15) Tabular SSAS improvements (Fixed/improved GUI and Processing steps).
  • (5794/8.Dec.15) Current partitioning errors for SSAS fixed. 
                               User comments on Measures etc. in Tabular SSAS models added.
  • (5799/9.Dec.15) Fixed Tabular SSAS processing (validation + skip unused columns).
  • (5801/9.Dec.15) Tabular SSAS fixes in UI change detection and validation.
  • (5804/11.Dec.15) Tabular SSAS fixes - Currency formatting, thousand separator removed from currency.
  • (5805/11.Dec.15) Remove copy/paste for Tabular SSAS tables. Use entire SSAS db for now.
  • (5806/11.Dec.15) SSAS XMLA fix - added WriteBackTableCreation=UseExisting.
  • (16.Dec.15) Installer fixed for Silent Install (32 bit).
 3. release  21. January 2016 Profitbase Studio 6.0 Build 5849
  • (5823/21.Dec.15) Password decryption for stored SQL server password fixed.
  • (5835/12.Jan.16) SSAS Current partition fixed (date limit and clean up after Current partition is moved).
  • (5836/13.Jan.16) Profitbase Server registration fixed (information stored when adding new server).
  • (5837/14.Jan.16) Fixed editing dialog for MDX formulas in P/C dimension details.
  • (5840/15.Jan.16) Validation of Calculated Fact Business Logic column (same type for name definition as for expression if aggregation functions to be used in SSAS.
  • (5843/19.Jan.16) Update of *Null/*Empty values when using Custom, Incremental or Transdate Reload of Data Source Tables.
  • (5844/20.Jan.16) Random ID seed added when creating a new solution databases. This is to avoid conflicts when adding multiple solutions based on same template on the same server.
  • (5846/20.Jan.16) Better post save handling when user tried to save an invalid Data Source column definition.
  • (5847/20.Jan.16) Validation of columns in Module Definitions (measure groups) added to avoid conflicts between source columns and added Business Logic columns).
  • (5848/21.Jan.16) Import of Business Logic from template and paste fixed.
  • (5849/21.Jan.16) Fixed second load option for drop down in Data Source Table transfer/process dialog when custom + incremental and/or transdate reload were enabled.
 4. release  4. February 2016 Profitbase Studio 6.0. Build 5868
  • (5851/27.Jan.16) Fixed rebug by 5846 on save of P/C Dimension Data Source columns.
  • (5855/27.Jan.16) Time Dimension AttributeHierarchyEnabled settings fixed.
  • (5856/27.Jan.16) New dialog for AD import in Access Control. New dialog to customize LDAP queries.
  • (5857/27.Jan.16) Fixed refresh in Data Browser dialog (null ref.error).
  • (5859/2.Feb.16) Allowed for Parallell data flow steps to be executed interactively.
  • (5859/2.Feb.16) Add/Remove column in existing dwh table for Parent/Child dimensions.  
  • (5859/2.Feb.16) Fixed PcDim Edit Table first time creation of table resulted in Preview error.
  • (5860/2.Feb.16) Ref.5836, corrected URI when adding connection to PB Server.
  • (5861/2.Feb.16) Ref.5855, Time Dimension Attributes visible/AttributeHierarchyEnabled handling (now handled as regular wide).
  • (5863/2.Feb.16) Fact Dimension available in Advanced SSAS Tasks (Delete and Process).
  • (5864/2.Feb.16) Changed "If you end this, you will lose status and error messages" message text.
  • (5865/2.Feb.16) Fixes on Save/State methods for parallel Data Flows etc.
  • (5866/2.Feb.16) Ref.5847, removed dialog on columns used in Business Logic. 
  • (5868/4.Feb.16) Ref.5861, Time Dimension - AttributeHierarchyEnabled  for related attributes and hierarchies.
 5. release  23. February 2016 Profitbase Studio 6.0. Build 5913
  • (5890/12.Feb.16) Fixed running Script Extension on Delete and Rebuild SSAS Database. Execution is working ok in earlier release but error message given. Reason is SSAS Trace has wrong start/end sequence.
  • (5891/12.Feb.16) Unknown handling was not correctly set. Default hidden was used.
  • (5892/12.Feb.16) Fiscal attribute Day was fixed in Time dimensions. The WeekDay language columns were wrongly used for Day attribute name.
  • (5904, 5905, 5913, 17-23.Feb.16) Time dimension fixes for hierarchies with week, Quarter property mapping and Attribute Hierarchy Enabled/Visible fixes.
  • (5906/18.Feb.16) Property attributes in Parent/Child dimension always visible.
  • (5913/23.Feb.16) New PFS with translations on Time YQMWD hierarchy. 
  • (5913/23.Feb.16) Ignore warning messages from SSAS server when creating/updating shared dimensions. This is less confusing and messages are repeated when committing other changes.
 6. release  29. March 2016 Profitbase Studio 6.0. Build 5951
  • ! (5913/2.Mar.16) Adding modifications from member scan for wide dimensions with different attributes using the same column. 
  • (5933/2.Mar.16) Fix for Internal source tables being wrongly interpreted as external source tables when doing initial creation and fill of distinct tables for views. This usually resulted in error when data source was DB2 or Oracle. Workaround was to select the source tables before running for example "Rebuild Module in DWH". The select operation will initialize the internal flag correctly.
  • ! (5941/15.Mar.16) Fixed metadata for Wide Dimensions. Fixed and added saving and validation of key attribute and attribute relations.
  • (5950/21.Mar.16) Commands for Create/Update of Time Dimension in SSAS are fixed.
  • (5950/21.Mar.16) Wide Dimension name column formatting was fixed to include correct value if null.
  • (5951/22.Mar.16) Fixed editing of Wide Dimensions including source changes and name translation columns for attributes.
 7. release  24. April 2016 Profitbase Studio 6.0. Build 5969 (replaced by 8.rel.)
  • (5960/15.Apr.16) Fix for Distinct Table scan when Script Extension folders have null as SubType.
  • ! (5960/15.Apr.16) Parallel fixes for lock when saving to Operation Log and retry when PK or Deadlock error for distinct and surrogate keys.
  • (5961/15.Apr.16) Select All Text in active cell in Datasource Table mapping grid.
  • (5962/17.Apr.16) Copy/Paste fixes w/retry, many-to-many and more.
  • (5962/17.Apr.16) Validation fixed for many-to-many and sub dimension.
  • (5962/17.Apr.16) Prevent upgrade to show when adding new solution to existing database upgraded from 5x
  • (5963/19.Apr.16) PFS fix w/longer field for Module Fact Table name. ! Upgrade the solution database ! Version number will stay the same.
  • ! (5963/19.Apr.16) Fixed SSAS Process by Time range to include all affected existing partitions.
  • ! (5966/20.Apr.16) Removed Week related hierarchies from Fiscal and Trade calendar. These attributes did not get values and resulted in processing errors.Week related attributes for fiscal and trade must be filled in manually from scripts etc.
  • (5966,5967/20.Apr.16) Default error settings added to main processing command in the processing dialog.
  • (5967/22.Apr.16) Fixed reduce code for dimensions in module. Dimensions (sub dims) were reduced against disabled fact sources. 
  • (5968/22.Apr.16) Fixed some GUI issues on SSAS Cube  Actions.
 8. release  5. May 2016 Profitbase Studio 6.0. Build 5972
  • ! (5971/4.May.16) Fixed double added key attributes in P/C dimensions when applied to SSAS databases.
  • (5971/4.May.16) Binding of P/C Dimensions in SSAS Measure Groups is limited to Key attributes to avoid errors.
  • (5971/4.May.16) Module Fact Source views in DWH is fixed for missing source columns when column is used against sub dimensions (that replaces source column based on a mapping table). Workaround is to add a dummy column. 
  • (5972/4.May.16) Time Dimension revisited to add week related hierarchies to Trade and Fiscal calendars when using 445/454/544 week patterns. Only regular Fiscal calendar does not support week related attributes and hierarchies.
  • ! Fixed build script for referencing correct Microsoft SQL 2014 SMO dll's in AnyCPU/x64 builds.
 Solved Fixes  Internal builds - contact Profitbase 
  • No further plans for any new 6.0 or 6.1 releases. Bugs will be fixed in 6.2.